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
members younger than 30 refers to age < 30; members older than 40 refers to age > 40; both conditions met refers to INTERSECT;