0

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;
0

Use movie.id in place of movie_id.

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

-1

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).

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .