To wirte 1 query I'll use rfrancisco's code
SELECT TOP 100 percent RIC AS RIC1,'' as SVCode, count(*)
FROM YourTable
WHERE Compliant = 1
GROUP BY RIC
UNION ALL
SELECT top 100 percent '' as RIC1, SVCode, count(*)
FROM YourTable
WHERE Compliant = 1
GROUP BY RIC, SVCode
ORDER BY RIC1 DESC, SVCode
Vasc