Show the studios that have produced films with director "Nicholas Meyer" and "Walter Hill".
CREATE TABLE film (Studio VARCHAR, Director VARCHAR)
SELECT Studio FROM film WHERE Director = "Nicholas Meyer" INTERSECT SELECT Studio FROM film WHERE Director = "Walter Hill"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (Studio VARCHAR, Director VARCHAR) Question: Show the studios that have produced films with director "Nicholas Meyer" and "Walter Hill". [/INST] SELECT Studio FROM film WHERE Director = "Nicholas Meyer" INTERSECT SELECT Studio FROM film WHERE Director = "Walter Hill" </s>