Show me all film studios in record.
select distinct studio from film
Show me all the directors in record.
select distinct director from film
Which studios have produced films with Nicholas Mayer?
select studio from film where director = "Nicholas Meyer"
Among those studios, which of them also have films with Walter Hill?
select studio from film where director = "Nicholas Meyer" intersect select studio from film where director = "Walter Hill"