Which event id does not have any participant with the detail Kneyatta Kuhn?
select event_id from events except select t1.event_id from participants_in_events as t1 join participants as t2 on t1.participant_id = t2.participant_id where participant_details = 'Kenyatta Kuhn'
And how about the detail "Karlee Batz"?
select event_id from events except select t1.event_id from participants_in_events as t1 join participants as t2 on t1.participant_id = t2.participant_id where participant_details = 'Karlee Batz'
Which event id does have a participant with the detail Kenyatta Kuhn?
select t1.event_id from events as t1 join participants_in_events as t2 join participants as t3 where participant_details = 'Kenyatta Kuhn'
How many events have the event detail fail?
select count ( * ) from events where event_details = 'Fail'