Database: apartment_rentals
Question: Show each apartment type code, and the maximum and minimum number of rooms for each type.
SQL:
SELECT apt_type_code ,  max(room_count) ,  min(room_count) FROM Apartments GROUP BY apt_type_code