How many parties are there?
select count ( * ) from party
Can you show me the names of the five parties?
select party_name from party
Can you tell me how many events are at each party?
select count ( * ) from party_events as t1 join party as t2 on t1.party_id = t2.party_id group by t1.party_id
Yes.
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