Database Foundations stage 7 problem

Sander;

This challenge has a long history of causing people some confusion. Here is a sample of the history.

Now, here is what the task is asking us to do:

Like before, group reviews by "movie_id", get the average "score" as "average" and filter out any averages over 2.

So first, your SQL filter statement is including the movie_id in the results, which the task is not requesting. Not sure if that is a make or break for this challenge necessarily, but it could through an error.

Secondly, the SQL statement which is filtering the average has the >= sign which is providing the incorrect results. We want to filter out movies which have an average score over 2, so they would have an average of under 2.

So, putting those two issues together, leaves us with a SQL statement like:

# Course: Database Foundations
# Module: SQL Calculating, Aggregating and Other Functions
# Challenge: Grouping, Joining, and Cleaning Up
# Task: 2 of 3:

SELECT AVG(score) AS average FROM reviews GROUP BY movie_id HAVING average <= 2;

I hope that makes some sense and helps.

Happy coding,

Ken