SELECT SD.Status0, Count(SD.Status0) AS ‘Count’
FROM v_GS_SOUND_DEVICE SD
GROUP BY SD.Status0