1. Count the number of listings by room type . Use the function 'AS' to rename the total count as 'n'. Display columns room_type and n.

Airbnb Data Dario Bonaretti | February 7, 2023 LISTING SCORE listing_id PK score_id PK listing_url scores_rating source REVIEWER scores_accuracy name reviewer_id PK scores_cleanliness description reviewer_name scores_checkin neighborhood_overview reviewer_gender scores_communication picture_url scores_location latitude scores_value longitude REVIEW fk_score_listing FK property_type review_id PK room_type date accomodates comments bathrooms LISTING AMENITIES_JOIN k_review_reviewer FK bathrooms_text FK listing_amenities_id PK fk_review_listing bedrooms fk_listing_amenitities_listing FK beds fk_listing_amenities_amenities FK amenities price HOSI minimum_nights host id PK AMENITIES maximum_nights host_url calendar_updated host_name amenities_id PK has_availability host_gender amenities availability_30 host_location availability_60 host_about availability_90 host is_superhost availability_365 host_neighbourhood NEIGHBORHOOD calendar_last_scraped host_thumbnail_url neighbourhood_id PK license host_picture_url neighbourhood_group instant bookable host_neighbourhood neighbourhood fk_listing_host FK host_identity_verified fk_listing_neighborhood FK host_since