show all info about members.
select * from member
which of them are older than 40?
select * from member where age > 40
for those who are younger than 30?
select * from member where age < 30
Which addresses have members in both groups?
select address from member where age < 30 intersect select address from member where age > 40