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 Giles Buchanan
Giles Buchanan
3,824 Points

Stuck on MySQL

on page http://teamtreehouse.com/library/grouping-joining-and-cleaning-up

task 1 of 3

I write an answer as below and it seems to give me the correct result but the page returns- Bummer! There's something wrong with your query.

SELECT movie_id, AVG(score) AS average FROM review GROUP BY movie_id

3 Answers

Giles Buchanan
Giles Buchanan
3,824 Points
Giles Buchanan
Giles Buchanan
3,824 Points

SELECT movie_id, AVG(score) AS average FROM reviews GROUP BY movie_id

sorry the above is the what I had been entering

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher
Andrew Chalkley
Andrew Chalkley
Treehouse Guest Teacher

Hi Giles,

We only require the average score. Drop the movie_id from the select clause.

Regards
Andrew

Giles Buchanan
Giles Buchanan
3,824 Points
Giles Buchanan
Giles Buchanan
3,824 Points

thanks got thru that one now the next one seems to be a problem SELECT AVG(score) AS average FROM reviews GROUP BY movie_id HAVING average > 2

again it works on the workbench but not in the task