Welcome to the Treehouse Community
Looking to learn something new?
the challenge is unclear
I have this challenge: Group all reviews by "movie_id" and get the average "score" and alias it as "average".
This is my answer: SELECT AVG(score) AS average FROM movies GROUP BY movie_id;
And i get this message: SQL Error: Unknown column 'score' in 'field list'
Steven Parker216,083 Points
The challenge says: Group all reviews by "movie_id" and get the average "score" and alias it as "average".
Note that the table name is reviews, not movies.
The database also contains a movies table, but that one has no score column.
Jonathan GrieveTreehouse Moderator 90,705 Points
I think that answer is correct. I'm making one or 2 assumptions here that the fields are correct.
I had an issue earlier when I attempted to copy a line of SQL code from one line that passed a task, to another because the questions were similar. The other challenge wouldn't pass even though it was right.
In order to pass, I had to manually type out the answer again. So however "painful" it might be try this again for your question and see it passes. It could easily be a challenge bug. :-)