Questions tagged [6.sql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
149 views

SQL QUERY MOVIES.DB

I have written the query for 6.sql but it does not work. SELECT AVG(rating) FROM ratings WHERE movie_id = (SELECT id FROM movies WHERE year = 2012); I can do this by using JOIN SELECT AVG(rating) ...
  • 86
0 votes
2 answers
337 views

pset7 6.sql rounding problem

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) ...
1 vote
1 answer
644 views

Why isnt it printing out the average?(pset7 6.sql)

SELECT AVG(rating) FROM ratings WHERE ratings.movie_id = (SELECT id FROM movies where movies.year = 2012); It doesnt seem to print anything.