How many unique apartment type codes are there?
select count(distinct apt_type_code) from apartments
What is the minimum room count for the departments?
select min(room_count) from apartments
List the apartment type code and the maximum and minimum number of rooms for each one.
select apt_type_code, max(room_count), min(room_count) from apartments group by apt_type_code