CREATE TABLE member (address VARCHAR, age INT)

Which address has both members younger than 30 and members older than 40?
SELECT address FROM member WHERE age < 30 INTERSECT SELECT address FROM member WHERE age > 40
SELECT "address" FROM "member" WHERE "age" < 30 INTERSECT SELECT "address" FROM "member" WHERE "age" > 40