CREATE TABLE party (party_name VARCHAR2, party_id VARCHAR2)
CREATE TABLE party_events (party_id VARCHAR2)

Show party names and the number of events for each party.
SELECT T2.party_name, COUNT(*) FROM party_events AS T1 JOIN party AS T2 ON T1.party_id = T2.party_id GROUP BY T1.party_id
SELECT "T2"."party_name", COUNT(*) FROM "party_events" "T1" JOIN "party" "T2" ON "T1"."party_id" = "T2"."party_id" GROUP BY "T1"."party_id"