How many female guests are there?
select count(*) from guests where gender_code = "Female"
What about male?
select count(*) from guests where gender_code = "Male"
What are the date of birth of them?
select date_of_birth from guests where gender_code = "Male"