You can use the script below to find how many systems of each type there are in Sedona Office
select b.system_code as System Type,
b.inactive as "System Code Inactive Y/N",
count(a.system_id) as "Number of Systems"
from ar_customer_system a, sy_system b
where a.system_id=b.system_id and a.Customer_Id > 1
group by b.system_code, b.inactive, a.system_id
order by b.system_code
