SELECT apt_type_code ,  max(room_count) ,  min(room_count) FROM Apartments GROUP BY apt_type_code
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
Show each apartment type code , and the maximum and minimum number of rooms for each type .