For each apartment booking, show the start date, and end date.
select booking_start_date, booking_start_date from apartment_bookings
Also show the type code with each record.
select t2.apt_type_code, t1.booking_start_date, t1.booking_start_date from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id
What are the booking start and end dates of the apartments with type code "Studio"?
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_type_code = "Studio"
How about the type code "Duplex"?
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_type_code = "Duplex"