Database: film_rank
Question: Show the studios that have produced films with director "Nicholas Meyer" and "Walter Hill".
SQL:
SELECT Studio FROM film WHERE Director  =  "Nicholas Meyer" INTERSECT SELECT Studio FROM film WHERE Director  =  "Walter Hill"