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 Alexander Davison
Alexander Davison
65,469 Points

(SQL) Please help!!!

It says "Bummer! Did you select from the "results" table?" and I can't figure it out! Here's my code:

SELECT * FROM results WHERE id >= "2015-10-01" AND away_team = "Hessle"

2 Answers

Chase Marchione
Chase Marchione
155,055 Points
Chase Marchione
Chase Marchione
155,055 Points

Hi xela,

I did some searching and I think I managed to find the objective you're working with (for future reference, you may receive a quicker response if you mention the name of the objective you're having an issue with.)

Interestingly, the error message you're getting is a little off: the real issue is that, instead of the id column, you're really looking to examine the played_on column, because played_on is the column where the dates of the matches are being stored (in contrast, the id column is used to give a unique identifier to each row.)

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

Hope this helps!

Alexander Davison
Alexander Davison
65,469 Points

Thank you!!!

Alexander Davison
Alexander Davison
65,469 Points

It really helped!

Jeremiah Montano
Jeremiah Montano
7,221 Points
Jeremiah Montano
Jeremiah Montano
7,221 Points

Without looking at the challenge, I dont think ID is the correct field for this. You may need to change that to another field that the date is being stored in.