For SQL queries for apartment_rentals database, the SECOND _T1.booking_startdate should be _T1.booking_enddate.
For example:
db_id:
apartment_rentals
questions:
Return the booking start date and end date for the apartments that have type code "Duplex".
SQL:
SELECT T1.booking_start_date , _T1.booking_startdate FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id = T2.apt_id WHERE T2.apt_type_code = "Duplex"
For SQL queries for apartment_rentals database, the SECOND _T1.booking_startdate should be _T1.booking_enddate.
For example:
db_id: apartment_rentals
questions: Return the booking start date and end date for the apartments that have type code "Duplex".
SQL: SELECT T1.booking_start_date , _T1.booking_startdate FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id = T2.apt_id WHERE T2.apt_type_code = "Duplex"