Cacher is the code snippet organizer for pro developers

SELECT DISTINCT b.Caption0,
                c.FileDescription +' '+left(c.fileversion,3) AS 'Version',
                                       count(c.FileDescription +' '+left(c.fileversion,3)) AS 'Count'
FROM v_r_system a
INNER JOIN v_gs_Operating_system b ON a.resourceid=b.resourceid
INNER JOIN v_GS_SoftwareFile c ON a.resourceid=c.resourceid
WHERE c.FileName = 'iexplore.exe'
  AND c.FilePath LIKE 'C:\prog%internet%'
  AND (a.client0=1
       AND a.Obsolete0=0
       AND a.Active0=1)
GROUP BY c.FileDescription +' '+left(c.fileversion,3),
                                b.Caption0