CS50_Labs/Lab7/movies/6.sql

select avg(rating) from ratings
join movies on movies.id = ratings.movie_id
where year = 2012;