What are dates of birth of all the guests whose gender is "Male"?
SELECT date_of_birth FROM Guests WHERE gender_code  =  "Male"
dates of birth of all guests refers to SELECT date_of_birth; whose gender is 'Male' refers to WHERE gender_code = 'Male';