Analyze Data SQL - WELP

What were the results of your query?

Could write it like this:

Summary
SELECT reviews.username, COUNT(*) AS negative_reviews
FROM reviews
JOIN places ON
reviews.place_id = places.id
WHERE reviews.rating < places.average_rating
GROUP BY 1
ORDER BY 2 DESC
LIMIT 1;

>>username	negative_reviews
@pinkdeb	7