What are the booking start and end dates of the apartments with more than 2 bedrooms ?
select t1.booking_start_date, t1.booking_start_date from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.bedroom_count > 2
Yes
select t1.booking_start_date, t1.booking_start_date from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.apt_number = "Apt. 585"
Okay, what are the dates for the apartment in building 225 ?
select t1.booking_start_date, t1.booking_start_date from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.building_id = "225"
What are the apartment numbers of all apartments with more than 2 bedrooms ?
select t2.apt_number from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.bedroom_count > 2