SELECT     TOP (100) PERCENT Manufacturer0 AS Manufacturer, Model0 AS Model, COUNT(Model0) AS Total
FROM         dbo.v_GS_COMPUTER_SYSTEM
GROUP BY Model0, Manufacturer0
ORDER BY Total DESC, Manufacturer, Model