Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

General Discussion

Posted by David Coel
David Coel
6,965 Points

HELP - MY SQL

What is wrong with my answer to the following code challenge:

Group all reviews by "movie_id" and get the average "score" and alias it as "average"

Proposed answer: SELECT movie_id, AVG(score) AS average FROM reviews GROUP BY movie_id;

Thanks

3 Answers

Richard Crawford-Wilson
Richard Crawford-Wilson
6,094 Points
Richard Crawford-Wilson
Richard Crawford-Wilson
6,094 Points

You dont want to select movie_id, it only asks for score.

SELECT AVG(score) AS average FROM reviews GROUP BY movie_id;
Tanner Sprague
Tanner Sprague
1,645 Points

I tried the exact same sql statement and it still doesn't work...

Ismail Qaznili
Ismail Qaznili
27,996 Points

Worked! Thanks for explaining that one.

Joshua Perry
Joshua Perry
2,962 Points

Thanks Richard!

David Coel
David Coel
6,965 Points
David Coel
David Coel
6,965 Points

Thanks, appreciate it.

CJ Williams
CJ Williams
34,372 Points
CJ Williams
CJ Williams
34,372 Points

I think the problem with this first question is that it doesn't specify which table we are getting the scores from:

SELECT AVG(score) AS average FROM ???? GROUP BY movie_id;

I did have the command right, but was referencing the movies table, not the reviews table.