SELECT Record_Company ,  COUNT(*) FROM orchestra GROUP BY Record_Company
How many orchestras does each record company manage?
SELECT Record_Company , COUNT ( * ) FROM orchestra GROUP BY Record_Company
select record_company , count ( * ) from orchestra group by record_company
How many orchestras does each record company manage ?