How many apartments are there?
select count ( * ) from apartments
The apt ID first.
select apt_id from apartments group by apt_id order by sum ( room_count ) desc limit 1
Now what is the apartment type code of that apartment.
select apt_type_code from apartments group by apt_type_code order by sum ( room_count ) desc limit 1