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
[{'apt_type_code': 'Duplex', 'max(room_count)': '9', 'min(room_count)': '3'}, {'apt_type_code': 'Flat', 'max(room_count)': '9', 'min(room_count)': '3'}, {'apt_type_code': 'Studio', 'max(room_count)': '9', 'min(room_count)': '6'}]