Machines Count By Server/Workstation OS Type

SELECT
ClientOSType =
CASE
    WHEN Operating_System_Name_and0 LIKE '%workstation%' THEN 'Total WorkStation OS'
    WHEN Operating_System_Name_and0 LIKE '%server%' THEN 'Total Server OS'
END,
COUNT(*)AS ClientCount
FROM v_r_system (NOLOCK)
WHERE
    client0 =1 AND obsolete0 =0 AND Active0=1
    AND Operating_System_Name_and0 IS NOT NULL
GROUP BY
CASE
    WHEN Operating_System_Name_and0 LIKE '%workstation%' THEN 'Total WorkStation OS'
    WHEN Operating_System_Name_and0 LIKE '%server%' THEN 'Total Server OS'
END