Which address has both members younger than 30 and members older than 40?
CREATE TABLE member (address VARCHAR, age INTEGER)
SELECT address FROM member WHERE age < 30 INTERSECT SELECT address FROM member WHERE age > 40
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE member (address VARCHAR, age INTEGER) Question: Which address has both members younger than 30 and members older than 40? [/INST] SELECT address FROM member WHERE age < 30 INTERSECT SELECT address FROM member WHERE age > 40 </s>