SELECT apt_type_code ,  bathroom_count ,  bedroom_count FROM Apartments GROUP BY apt_type_code ORDER BY sum(room_count) DESC LIMIT 1
Show the apartment type code that has the largest number of total rooms, together with the number of bathrooms and number of bedrooms.
SELECT apt_type_code , bathroom_count , bedroom_count FROM Apartments GROUP BY apt_type_code ORDER BY sum ( room_count ) DESC LIMIT 1
select apt_type_code , bathroom_count , bedroom_count from apartments group by apt_type_code order by sum ( room_count ) desc limit value
Show the apartment type code that has the largest number of total rooms , together with the number of bathrooms and number of bedrooms .