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 trialElaine Tran
809 PointsIs there a better way to solve "Find all the invalid ratings in one query." I did NOT IN (1,2,3,4,5).
-- Review ratings should be only be 1-5. Find all the invalid ratings in one query
SELECT * FROM reviews WHERE rating NOT IN (1, 2, 3,4,5);
It worked, but I'm wondering if there's a better way. Thanks in advance.
4 Answers
Joel Bardsley
31,249 PointsYou could use the BETWEEN operator, which would make the query:
SELECT * FROM reviews WHERE rating NOT BETWEEN 1 AND 5;
Diana Ci
18,672 PointsSELECT * FROM reviews WHERE rating < 1 OR rating > 5;
sradms0
Treehouse Project ReviewerSELECT * FROM reviews WHERE rating NOT BETWEEN 1 AND 5 OR rating IS NULL;
Mohammed Safiulla D
17,044 PointsI guess it's always better to be explicit when coding however I tried for columns where information was NULL (for example the year_released in movies table; there are no reviews with null ratings). I found that NOT BETWEEN removes NULL values by default. The following 2 lines give the same result :
select * from movies where year_released not between 2000 and 2005;
select * from movies where year_released not between 2000 and 2005 or year_released is null;
Still, I would do what you did and always be explicit while coding :)
Codeon Tech
1,150 PointsSELECT * FROM reviews WHERE rating IN (5);
Elaine Tran
809 PointsElaine Tran
809 PointsThank you Joel! :)