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

We'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

Hi 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"

Tobias Helmrich
Tobias Helmrich
31,603 Points

Yep, it's working just fine for me!

Steven Parker
Steven Parker
231,261 Points

Sometimes 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
Tobias Helmrich
31,603 Points

Hey 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.

Perfect, thanks