SELECT v_GS_SOUND_DEVICE.ProductName0 AS ‘Name’, Count(v_GS_SOUND_DEVICE.ProductName0) AS ‘Count’

FROM v_GS_SOUND_DEVICE v_GS_SOUND_DEVICE

GROUP BY v_GS_SOUND_DEVICE.ProductName0

ORDER BY v_GS_SOUND_DEVICE.ProductName0