pset7 6.sql rounding problem

Question

My code works fine but check50 give me an error because it´s not rounded the same way. :( 6.sql produces correct result expected "7.74", not "7.75"

SELECT ROUND(AVG(rating), 2) FROM ratings
JOIN movies ON ratings.movie_id = movie_id
WHERE year = 2012;

Answer 1

Use movie.id in place of movie_id.

Hope this helps. If it does, check the tickmark.

Answer 2

The default for JOIN in SQL is INNER JOIN; which is a form of intersection. Thus what you select should have the dot(.) operator to be effective (ratings.rating and movies.id).