CREATE TABLE party_events (member_in_charge_id VARCHAR2)
CREATE TABLE member (member_name VARCHAR2, member_id VARCHAR2)

What is the name of member in charge of greatest number of events?
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
SELECT "T1"."member_name" FROM "member" "T1" JOIN "party_events" "T2" ON "T1"."member_id" = "T2"."member_in_charge_id" GROUP BY "T2"."member_in_charge_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY