Select USB.Manufacturer0, count(USB.Manufacturer0) as ‘Total’
From dbo.v_GS_USB_DEVICE USB
Group By USB.Manufacturer0