show me the apartment type for the 7 apartments
SELECT t2.apt_type_code FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id   =   T2.apt_id WHERE T1.booking_status_code   =   "Confirmed"
apartment type refers to apt_type_code; for the 7 apartments implies there may be a condition or limitation that wasn't specified in the SQL code regarding the quantity '7'; show me refers to SELECT; JOIN is used to combine rows from two or more tables based on a related column between them; WHERE clause is used to filter records; booking_status_code = 'Confirmed' filters apartments with a confirmed booking status;