Show me all the information for all the party events?
select * from party_events
Also show all the distinct member information of those in charge of them?
select * from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id
Now just show me the distinct members information for all the members other than those?
select * from member except select * from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id
Just show me their names!
select member_name from member except select t1.member_name from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id