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


results returned but something vague wrong?

I used this command: select movie_id, avg(score) as average from reviews group by movie_id;

and received a list of movie_id's and their average scores, but for some reason this doesn't satisfy the question.

Hi Helin,

Which code challenge is this for?

1 Answer

Sergey Podgornyy
Sergey Podgornyy
20,660 Points

Maybe you need just:

SELECT avg(score) AS average FROM reviews GROUP BY movie_id;

What kind of Error do you become from Treehouse? Can you post it here? This can be helpful