Show me all the event ids, event names and party id for each party_event.
select event_id, event_name, party_id from party_events
How events are there for every party?
select party_id, count(*) from party_events group by party_id
How about for every event name?
select event_name, count(*) from party_events group by event_name
Which event names have at least 2?
select event_name from party_events group by event_name having count(*) > 2