Customer Counts by Customer Types

You can use the script below to find how many customers of each type.

select b.type_code  as "Query 8  - AR_Customer - Type of Customer - **Provide results to the customer to review for accuracy**", 

b.inactive as "Customer Type Inactive?", count(a.customer_type_id) as "Number of Customers"

from ar_customer a, ar_type_of_customer b

where a.customer_type_id=b.type_id

and a.customer_id<>1

group by b.type_code, b.inactive, a.customer_type_id