Reviews
The second slide shows what customers think of the games. Split the reviews into three groups by their stars, as in the lesson on functions: positive for 4 or 5 stars, neutral for 3 stars and negative for fewer. For each group, show the verdict, the number of reviews as review_count, and how many of them have a comment as with_comment, the biggest group first:
| verdict | review_count | with_comment |
|---|---|---|
| positive | 18 | 11 |
| neutral | 5 | 2 |
| negative | 2 | 2 |
A tip: what COUNT counts depends on what's in its parentheses.
Instructions
Below the comment -- 2. Reviews, write the query for the second slide.
Start programming for free
2/3