How many films are there?
select count(*) from film
Show me all film studios in record.
select distinct studio from film
How many films does each of them have?
select studio, count(*) from film group by studio
Show me the name of the studio that have the most.
select studio from film group by studio order by count(*) desc limit 1