You can use the script below to see how many systems are being serviced by each service company
select b.service_company_code as "Service Company",
b.inactive as "Service Company Code Inactive Y/N", --b.service_company_id,
count(a.service_company_id) as "Number of Systems with Service Company Code", b.description
from ar_customer_system a, sv_service_company b
where a.service_company_id=b.service_company_id and a.Customer_Id > 1
group by b.service_company_code, b.inactive, a.service_company_id, b.service_company_id, b.description
order by b.service_company_code
