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
Abdus Samad
2,307 PointsPlease check what went wrong with my SQL statement..?
We're back in the sports team database. There's a results table with the columns id, home_team, home_score, away_team, away_score and played_on . Find all the matches in the results table where "Hessle" was playing away as the away team and if they played on or after October 1st 2015. Date format is "YYYY-MM-DD".
Ans: SELECT * FROM results WHERE away_team = "Hessle" AND played_on "2015.10.01" OR played_on > "2015.10.01";
2 Answers
Ryan S
27,276 PointsHi Abdus,
It would be helpful if you could provide a link to the challenge you are working on.
But there are a few things I can point out.
First take a look at your date format. The question specifically states "YYYY-MM-DD" yet you are using "YYYY.MM.DD".
And the other thing I will mention is take note of the wording in the question : "played on or after October 1st 2015". Consider using the relational operator, greater than or equal to ( >= )
SELECT * FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01";
Abdus Samad
2,307 PointsThanks for your quick response..!
How do I provide the link..? In the system it was already attached, I don't know why didn't you received it. May be something went wrong..!
Ryan S
27,276 PointsNo problem.
Well if you already attached it then maybe there is an issue with the Database courses. I've noticed that Database questions never seem to have links to the challenges attached and up until this point I assumed that people just forgot. But maybe there is a bug of some sort?