human
Schema:
Services (Service_ID, Service_Type_Code)
Participants (Participant_ID, Participant_Type_Code, Participant_Details)
Events (Event_ID, Service_ID, Event_Details)
Participants_in_Events (Event_ID, Participant_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
How many unique participant types are there?
assistant
SELECT COUNT( distinct participant_type_code ) FROM participants;
human
How many people are with the type 'Participant'?
assistant
SELECT COUNT( * ) FROM participants WHERE participant_type_code = 'Participant';
human
What about 'Organizer'?
assistant
SELECT COUNT( * ) FROM participants WHERE participant_type_code = "Organizer" ;