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
apartment type code refers to apt_type_code; maximum number of rooms for each type refers to MAX(room_count); minimum number of rooms for each type refers to MIN(room_count);