How to write the code of the last question of Welp

Data Science
1

Businesses want to be on the lookout for …ahem… difficult reviewers. Write a query that finds the reviewer with the most reviews that are BELOW the average rating for places.

2

Please furnish us with a link to the exercise.

1 Like
3

To write code for the last question in Welp, review its requirements, clarify inputs/outputs, and break down logic into manageable steps. Use comments and testing to ensure functionality aligns with expectations.

4

CGPT replies aren’t helpful, ever. (they also violate the Community Guidelines).

5

This is the link to the project:

https://www.codecademy.com/paths/analyze-data-with-sql/tracks/analyze-data-sql-join-data/modules/analyze-data-sql-practice-joins/projects/sql-welp

So, in situations like this, it helps to try to put things in your own words and break down the question into your own lexicon.

You want to find the one reviewer who has the most negative reviews, more so than the average rating for places.

What’s that look like?

  • what’s the average rating for places?
  • look at all reviewers and then order them and limit it to the one person who has the most negative reviews.

What SQL clauses would you use here? You’d probably want to use:

  • JOIN
  • WHERE
  • GROUP BY
  • ORDER BY
  • LIMIT

Some of these results from previous topics also might help:
https://discuss.codecademy.com/search?q=welp%20project