CREATE TABLE Apartments (apt_type_code VARCHAR, room_count INT)

Show the top 3 apartment type codes sorted by the average number of rooms in descending order.
SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY AVG(room_count) DESC LIMIT 3
SELECT "apt_type_code" FROM "Apartments" GROUP BY "apt_type_code" ORDER BY AVG("room_count") DESC NULLS LAST LIMIT 3