Which address has both members younger than 30 and members older than 40?
CREATE TABLE member (address VARCHAR, age INTEGER)
[SQL] SELECT address FROM member WHERE age < 30 INTERSECT SELECT address FROM member WHERE age > 40 [/SQL]