How many different member in charges are there for all party_events?
select count(distinct member_in_charge_id) from party_events
What are their names?
select t1.member_name from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id group by t2.member_in_charge_id
How many events are they each in charge of?
select t1.member_name, count(*) from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id group by t2.member_in_charge_id
Who has the greatest number?
select t1.member_name from member as t1 join party_events as t2 on t1.member_id = t2.member_in_charge_id group by t2.member_in_charge_id order by count(*) desc limit 1