Task: Text to Code
Input (English): How many orchestras does each record company manage?
Output (English): SELECT Record_Company ,  COUNT(*) FROM orchestra GROUP BY Record_Company