SELECT  PFI.CompanyName,
Count(PFI.CompanyName) AS ‘Count of CompanyName’
FROM  v_ProductFileInfo PFI
GROUP BY PFI.CompanyName