SELECT Studio FROM film GROUP BY Studio ORDER BY COUNT(*) DESC LIMIT 1
What is the name of teh studio that created the most films?
SELECT Studio FROM film GROUP BY Studio ORDER BY COUNT ( * ) DESC LIMIT 1
select studio from film group by studio order by count ( * ) desc limit value
What is the name of teh studio that created the most films ?