Grouping, joining and cleaning up objectives challenge task 3 of 3 solution?

you need to switch the reviews table with movies table in the join statement. Also, you are missing part of the having condition.

My solution as follows select movies.title,IFNULL(avg(score),0) as average from movies left outer join reviews on movies.id=reviews.movie_id group by movie_id having average <2;

Hi,

first you need to select from movies because you want to display the movies title. Consequently you need to perform a left outer join with the reviews table. You had that the other way round.

Then, I am not sure if I am jut not seeing you declare that the averages need to be under 2. It might be the formatting here. Average needs to be singular, then you add the operator and then the number.

Your statement should look like this:

SELECT movies.title,
       IFNULL(AVG(score),0) AS average
FROM movies 
LEFT OUTER JOIN reviews 
ON movies.id = reviews.movie_id
GROUP BY movie_id 
HAVING average < 2;

Thanks everyone. It worked