Airbnb gives some hosts "superhost" status. The trust team wants to check that superhosts really do earn better reviews.
Compare reviews for listings run by superhosts and by regular hosts: show the number of reviews and the average stars for each group.
Expected output
host_type is 'superhost' or 'regular'; avg_stars rounded to 2 decimalsExample of the shape (made-up values):
| host_type | reviews | avg_stars |
|---|---|---|
| superhost | 300 | 4.31 |
| regular | 700 | 4.05 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.