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 the apartment type codes and apartment numbers in the buildings managed by "Kyle"?
select t2.apt_type_code, t2.apt_number from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id where t1.building_manager = "Kyle"