Please list each gender code with its corresponding amount of guests and sort it in descending order by that count?
select gender_code, count ( * ) from guests group by gender_code order by count ( * ) desc
What are the full names of all the people with unknown genders?
select guest_first_name, guest_last_name from guests where gender_code = "Unknown"
What were their birth dates?
select date_of_birth from guests where gender_code = "Unknown"
What are the birth dates of all guests with the letter M in their first or last name?
select date_of_birth from guests where guest_first_name like '%m%' or guest_last_name like '%m%'