What is the average gross amount of money made in dollars?
select avg ( gross_in_dollar ) from film
What films did Nicholas Meyer direct?
select title from film where director = "Nicholas Meyer"
What were those movies directed by Walter Hill?
select title from film where director = "Walter Hill"
What studio produced that movie with name 48 Hrs?
select studio from film where title = "48 Hrs"
What studio produced Star Trek II: The Wrath of Khan?
select studio from film where title = "Star trek ii: the wrath of Khan"