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