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 trialAman Maru
1,168 PointsWe're back in the sports team database. There's a results table with the columns id, home_team, home_score, away_team,
select * from results WHERE away_team = "Hessle" AND played_on >= "2015-10-01"; I keep getting an error saying i'm missing a where clause
4 Answers
Aman Maru
1,168 PointsHi Tobias thanks I kept clicking it and eventually it worked. now for the next question: We have an e-commerce database. Inside the products table we have the columns of id, name, description and price. Without using the OR keyword, find all products with the price of 7.99, 9.99 or 11.99. My answer is SELECT * FROM products WHERE price IN ("7.99","9.99","11.99"). Could you confirm this is correct. I am getting the same error. "Missing where clause"
Steven Parker
231,261 PointsSometimes the challenge checker will misinterpret an error and give you the wrong hint. My guess is you had your WHERE in place the whole time, but there was a typo somewhere else that was throwing it off.
But if you got that error, and then cleared it up ONLY by clicking re-try, without making any changes, that sounds like a bug. You might want to report that to Treehouse Support.
Tobias Helmrich
31,603 PointsHey Aman,
are you doing the "Filtering by Dates" challenge in the SQL Basics course? I just pasted your query there and it worked perfectly fine! Maybe you should try refreshing the page and trying it once again.
Aman Maru
1,168 PointsPerfect, thanks
Tobias Helmrich
31,603 PointsTobias Helmrich
31,603 PointsYep, it's working just fine for me!