CREATE TABLE Apartments (apt_type_code VARCHAR2, room_count NUMBER)

Show each apartment type code, and the maximum and minimum number of rooms for each type.
SELECT apt_type_code, MAX(room_count), MIN(room_count) FROM Apartments GROUP BY apt_type_code
SELECT "apt_type_code", MAX("room_count"), MIN("room_count") FROM "Apartments" GROUP BY "apt_type_code"