SELECT Record_Company FROM orchestra GROUP BY Record_Company ORDER BY COUNT(*) DESC LIMIT 1
What is the record company used by the greatest number of orchestras?
SELECT Record_Company FROM orchestra GROUP BY Record_Company ORDER BY COUNT ( * ) DESC LIMIT 1
select record_company from orchestra group by record_company order by count ( * ) desc limit value
What is the record company used by the greatest number of orchestras ?