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

Databases

Posted by Craig Okeeffe
Craig Okeeffe
1,050 Points

what 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
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

You 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
Ali Al Hudari
9,876 Points
Ali Al Hudari
Ali Al Hudari
9,876 Points

the right answer with simple modifications

SELECT min(rating) AS star_min, Max(rating) as star_max FROM reviews WHERE movie_id = 6;