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
Craig Okeeffe
1,050 Pointswhat is wrong with this statement SELECT MIN(rating) AS star_min, MAX(rating) AS star_max, movie_id FROM reviews WHERE m
Hello. Need some assistance with this statement. SELECT MIN(rating) AS star_min, MAX(rating) AS star_max, movie_id FROM reviews WHERE movie_id =6; from Reporting with SQL Calculations section Task 1.
2 Answers
Steven Parker
231,128 PointsYou did a little bit too much.
Even though you need it for your WHILE clause, you don't need to show the movie_id column in the SELECT list. The challenge only wanted the min and max results.
Remove it and you'll pass the challenge.
Ali Al Hudari
9,876 Pointsthe right answer with simple modifications
SELECT min(rating) AS star_min, Max(rating) as star_max FROM reviews WHERE movie_id = 6;