Database: film_rank
Question: What are the names of studios that have produced films with both Nicholas Meyer and Walter Hill?
SQL:
SELECT Studio FROM film WHERE Director  =  "Nicholas Meyer" INTERSECT SELECT Studio FROM film WHERE Director  =  "Walter Hill"