What are all the distinct participant ids who attended any events?
create table participants_in_events (participant_id varchar, PRIMARY KEY (participant_id))
select count(distinct participant_id) from participants_in_events