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