SELECT  VC.Name0,
Count(VC.Name0) AS ‘Count’
FROM v_GS_VIDEO_CONTROLLER VC
GROUP BY VC.Name0