Can you show me the top 3 highest room counts?
select room_count from apartments order by room_count desc limit 3
yes
select apt_type_code, avg ( bathroom_count ), avg ( bedroom_count ), avg ( room_count ) from apartments group by apt_type_code
Can you tell me the average number of rooms for each apartment type code?
select apt_type_code, avg ( room_count ) from apartments group by apt_type_code
Can you sort them in descending order?
select apt_type_code, avg ( room_count ) from apartments group by apt_type_code order by avg ( room_count ) desc
Can you show me just the apartment type codes of the top 3?
select apt_type_code from apartments group by apt_type_code order by avg ( room_count ) desc