What are the apartment numbers of all apartments with more than 2 bedrooms ?
SELECT  T2.apt_number FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id   =   T2.apt_id WHERE T2.bedroom_count  >  2
apartment numbers of apartments with more than 2 bedrooms refers to SELECT ... FROM ... WHERE bedroom_count > 2;