Select
SOFT.ProductName0 as ‘Browser Name’,
Soft.Publisher0,
Count(SOFT.ProductName0) as ‘Count’
FROM
v_GS_INSTALLED_SOFTWARE_CATEGORIZED SOFT
WHERE
SOFT.ProductName0 LIKE ‘Mozilla Firefox%’
OR SOFT.ProductName0 LIKE ‘Safari’
OR SOFT.ProductName0 LIKE ‘%Internet Explorer%’
OR SOFT.ProductName0 LIKE ‘%Google Chrome%’
Group by
SOFT.ProductName0,
Soft.Publisher0