SELECT apt_number FROM Apartments ORDER BY room_count ASC
Sort the apartment numbers in ascending order of room count.
SELECT apt_number FROM Apartments ORDER BY room_count ASC
select apt_number from apartments order by room_count asc
Sort the apartment numbers in ascending order of room count .