CREATE TABLE Apartments (apt_id VARCHAR2, apt_type_code VARCHAR2)
CREATE TABLE Apartment_Bookings (booking_start_date VARCHAR2, apt_id VARCHAR2)

What are the booking start and end dates of the apartments with 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"
SELECT "T1"."booking_start_date", "T1"."booking_start_date" FROM "Apartment_Bookings" "T1" JOIN "Apartments" "T2" ON "Duplex" = "T2"."apt_type_code" AND "T1"."apt_id" = "T2"."apt_id"