Que endereço tem membros com menos de 30 anos e membros com mais de 40 anos?
CREATE TABLE member (address VARCHAR, age INTEGER)
SELECT address FROM member WHERE age < 30 INTERSECT SELECT address FROM member WHERE age > 40