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:

verdictreview_countwith_comment
positive1811
neutral52
negative22

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

By signing up, you agree to the Terms of Service and Privacy Policy.

Or sign up with:

2/3