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

Tarun Sharna
Tarun Sharna
873 Points
Posted by Tarun Sharna
Tarun Sharna
873 Points

I am not sure what's wrong with this statement.

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

Answer SELECT id, home_team, home_score, away_team, away_score, played_on FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01";

1 Answer

Katie Wood
Katie Wood
19,141 Points

Hi there,

It looks mostly fine - sometimes the challenges get picky about listing all of the columns instead of using the * character to select all of them. To start, I would try changing all of the listed columns to * instead, and see if that works. It would look something like this:

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

I don't see any other immediate issues, so hopefully that will work for you.

Tarun Sharna
Tarun Sharna
873 Points
Tarun Sharna
Tarun Sharna
873 Points

Thanks katie. It worked great. the next challenge also gave me the same error and by adding the * selector it worked. Thank you so much. :)