[SQL문제풀기] Number Of Bathrooms And Bedrooms

문제

StrataScratch - Number Of Bathrooms And Bedrooms

StrataScratch

https://platform.stratascratch.com/coding/9622-number-of-bathrooms-and-bedrooms?code_type=3

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select city,property_type, 
        avg(bathrooms) "average number of bathrooms",
        avg(bedrooms) "average number of bedrooms"
from airbnb_search_details
group by city,property_type;