Hi how are you!?  Can you provide me with a list of all of the different member names?
select distinct member_name from member
Excellent!  Thanks for that!  Can you add to this list the event name associated with each member name?
select distinct member_name, t2.event_name from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id
Alright!  Can you please show me a list of all member names who are not associated with any event?
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