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

General Discussion

Posted by Venkatesh Nagarajan
Venkatesh Nagarajan
1,169 Points

Filtering by dates objective: SELECT * FROM results WHERE away_team = "Hessle" and played_on >= "2015-10-01";

I get an error stating "You're missing a where clause". Can you tell me what is wrong with my statement?

2 Answers

Ethan Weeks
Ethan Weeks
15,352 Points
Ethan Weeks
Ethan Weeks
15,352 Points

I have the same thing and it worked. weird.

> SELECT * FROM results WHERE away_team = 'Hessle' AND played_on >= '2015-10-01';

Remember to post your questions with the video or challenge. It makes answer them much easier and you will get them answered much faster.

Pablo Caro
Pablo Caro
4,191 Points
Pablo Caro
Pablo Caro
4,191 Points

I received the same error, I had a similar error in a previous example but changing Where to all caps worked. It is not working this time