List all the booking start and end dates.
select booking_start_date, booking_start_date from apartment_bookings
Show the bedroom number of each record.
select t1.booking_start_date, t1.booking_start_date, t2.bedroom_count from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id
Show the start and end dates of the apartment bookings made by male guests.
select t1.booking_start_date, t1.booking_start_date from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t2.gender_code = "Male"
What about female guests?
select t1.booking_start_date, 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"