Hello. What are the IDs of guests with gender code Female?
select guest_id from guests where gender_code = "Female"
Show me the start dates of apartment bookings by these IDs please.
select t1.booking_start_date from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t2.gender_code = "Female"
Show me the start dates and end dates of apartment bookings by these IDs please.
select t1.booking_start_date, t1.booking_end_date from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t2.gender_code = "Female"
Can you give me the apartment ids for the same list?
select t1.apt_id from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t2.gender_code = "Female"