Count IE by domain?

[kingskawn]

I need to make a report to see the IE version (6/7/8/9/10/11) but ordered by domain name.
Can this be done?

Example:

Domain name Count Version
Domain A 223 IE9
Domain B 459 IE8
Domain A 353 IE10
Domain C 105 IE8
Domain A 704 IE8

[kingskawn]

Wow, very nice RC62N. It worked directly! Thanks a lot

[RCorbeil · Accepted solution]

SELECT
  Top 1000000
  tblAssets.Domain,
  tblSoftwareUni.softwareName,
  Count(*) AS Total
FROM
  tblAssets
  INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
  INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
  tblAssetCustom.State = 1
  AND tblSoftwareUni.softwareName LIKE 'Windows Internet Explorer%'
GROUP BY
  tblAssets.Domain,
  tblSoftwareUni.softwareName