SELECT IDE.Name0, Count(IDE.Name0) AS ‘Count of Name0’
FROM v_GS_IDE_CONTROLLER IDE
GROUP BY IDE.Name0