If you are writing a query for reviews which are below the overall average of
places.average_rating then you might want to reconsider your
WHERE clause. You want to find the reviews with a
rating below a specific value in that case. Note that would be all reviews, not some kind of average.
Double check the original text too to make sure you SELECT the right information too with regards to the requirement.
I got a little confused with the interpretation of this point. It could be that you’re looking for reviews (per place) that are below the average rating (column) of the each individual place in the places table (
places.average_rating) rather than an overall average. So you’d be hunting out every review for a single place that is below the
average_rating of that place and then dealing with that data. I couldn’t say for certain though and perhaps you could write a query for both if you’re looking for practice.