How many events are there in total?
select count(*) from participants
Among those, which of them had participants whose details had the substring 'Miss'
select * from participants as t1 join participants_in_events as t2 on t1.participant_id = t2.participant_id where t1.participant_details like '%miss%'
What about 'Dr.'?
select * from participants as t1 join participants_in_events as t2 on t1.participant_id = t2.participant_id where t1.participant_details like '%dr.%'
How many are there in total?
select count(*) from participants as t1 join participants_in_events as t2 on t1.participant_id = t2.participant_id where t1.participant_details like '%dr.%'