Can you show me the numbers of the apartments?
select count ( * ) from apartments
Of those apartments, which ones have more than 2 bedrooms?
select count ( * ) from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.bedroom_count > 2
Can you provide the booking start dates and end dates, for all 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