SELECT  MB.PrimaryBusType0,
Count(MB.PrimaryBusType0) AS ‘Count’
FROM
v_GS_MOTHERBOARD_DEVICE MB
GROUP BY MB.PrimaryBusType0