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

Development Tools Database Foundations SQL Calculating, Aggregating and Other Functions Grouping, Joining and Cleaning Up

Posted by . Ali
. Ali
9,799 Points

Just a heads up

There are a coupe of things that needs to be reviewed. In first question the table name is not mentioned but who ever has made questions has assumed that we should select REVIEWS TABLE.

Then the following question, Like before, group reviews by "movie_id", get the average "score" as "average" and filter out any averages over 2., return error when you do it.

But if you return results where average is less than 2 then it accepts the answer. please do review these questions. thanks

bothxp
bothxp
16,510 Points

It looks like it's accepting <=2 now.

1 Answer

bothxp
bothxp
16,510 Points
bothxp
bothxp
16,510 Points

ignore me .... it is still accepting both < 2 and <=2

also apparently trying to edit a comment actually creates a new answer (using FireFox 28)