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.