SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')

Uncategorized