What are the apartment type codes?
select apt_type_code from apartments
What are the Maximum rooms for each Apartment type code?
select apt_type_code, max ( room_count ) from apartments group by apt_type_code
What are the Minimum rooms for each Apartment type code?
select apt_type_code, min ( room_count ) from apartments group by apt_type_code
What is the Apartment type code of building id 808?
select apt_type_code from apartments where building_id = 808