What are all the information about the apartments.
select * from apartments
Order those records by the number of total rooms.
select * from apartments order by room_count
Which is the apartment type code that has the largest number of total rooms?
select apt_type_code from apartments group by apt_type_code order by sum(room_count) desc limit 1
Order the apartment type code by the number of total rooms.
select apt_type_code from apartments group by apt_type_code order by sum(room_count) desc
Add the number of bathrooms and number of bedrooms to the results.
select apt_type_code, bathroom_count, bedroom_count from apartments group by apt_type_code order by sum(room_count) desc limit 1