Airbnb stores each listing's amenities as one comma-separated text value, like 'Wifi,Kitchen,Washer'. The search team wants to know which amenities are most common.
For each amenity, show how many listings offer it and that number as a percentage of all listings.
Expected output
pct_of_listings rounded to 1 decimal; any row orderExample of the shape (made-up values):
| amenity | listings | pct_of_listings |
|---|---|---|
| Wifi | 120 | 40.0 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.