Show me all film studios in record.
select distinct studio from film
What are the maximum gross for their films?
select studio, max(gross_in_dollar) from film group by studio
What about the average?
select studio, min(gross_in_dollar) from film group by studio
Show me the name of studios that have average above 4500000.
select studio from film group by studio having avg(gross_in_dollar) >= 4500000