What dates are these apartments booked for?
select t2.apt_number, t1.booking_start_date, t1.booking_end_date from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.booking_status_code = "Confirmed"
How many of these apartments have 3 bedrooms?
select count ( * ) from apartments where apt_number in ( select distinct t2.apt_number from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.booking_status_code = "Confirmed" ) and bedroom_count = 3
How many bathrooms are in each of these apartments?
select bathroom_count from apartments where apt_number in ( select distinct t2.apt_number from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.booking_status_code = "Confirmed" ) and bedroom_count = 3