Database: orchestra
Question: How many orchestras does each record company manage?
SQL:
SELECT Record_Company ,  COUNT(*) FROM orchestra GROUP BY Record_Company