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 studios that have at least two.
select studio from film group by studio having count(*) >= 2