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 Will Anderson
Will Anderson
28,683 Points

Why do I get an error, 'Bummer! You're missing a WHERE clause', when it's there?

SQL Basics Code Challenge: Don't use OR to find multiple values from 7.99, 8.99 and 11.99.

Attached is my code. <scratches head, 'How could this be?'>

Will Anderson
Will Anderson
28,683 Points

Code: SELECT * FROM products WHERE price IN (7.99, 9.99, 11.99) ;

I'll have to learn how Treehouse uses automatic check-boxes to include code ;-)

Thanks for the reply!

Jason Anello
Jason Anello
Courses Plus Student 94,610 Points

Hi Will,

Maybe try again. The code you have posted passes the challenge.

2 Answers

Will Anderson
Will Anderson
28,683 Points

Jason answered and he is correct. The test is code construction sensitive, unlike MS SQL Management Studio or Oracle SQL Developer. When I put it all in one line, the challenge accepted it. When I wrote a separate line for each command, including the semi-colon, it failed the code. I use the more maintainable method of line per command, but I guess that's not gonna work here.

Thanks guys for your support! +1

Shawn Denham
seal-mask
PLUS
.a{fill-rule:evenodd;}techdegree
Shawn Denham
Python Development Techdegree Student 17,801 Points
Shawn Denham
.a{fill-rule:evenodd;}techdegree
Shawn Denham
Python Development Techdegree Student 17,801 Points

Don't see your code :(