Count of Modem Types

My test database has External Modem, Internal Modem, and Null Modem

SELECT MOD.DeviceType0,
Count(MOD.DeviceType0) AS ‘Count of DeviceType0’
FROM v_GS_MODEM_DEVICE MOD
GROUP BY MOD.DeviceType0