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