I have a question about the project ‘Welp’ from Analyze Data with SQL. Specifically, I am concerned with task 9.
The assignment is: ‘Companies want to be on the lookout for …um… difficult reviewers. Write a query that finds the reviewer with the most ratings that are BELOW the average rating for places.’
For this I wrote the following query and nothing is put out to me.
SELECT COUNT(places.average_rating), reviews.username
LEFT JOIN places
ON reviews.id = places.id
WHERE places.average_rating < AVG(places.average_rating)
ORDER BY places.average_rating DESC
GROUP BY reviews.username
This is the task:
Since the hint is also relatively little, I can’t manage to find the solution.
Can you help me?