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