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 Arun Kanagala
.a{fill-rule:evenodd;}techdegree
Arun Kanagala
iOS Development Techdegree Student 617 Points

Help me with this Query, since its giving me error.

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

here is my query: SELECT id, home_team, home_score, away_team, away_score, played_on FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01";

2 Answers

Jason Anello
Jason Anello
Courses Plus Student 94,610 Points

Hi Arun,

It seems that the challenge wants you to use an asterisk, *, to select all the columns instead of listing them all out as you have.

Arun Kanagala
seal-mask
.a{fill-rule:evenodd;}techdegree
Arun Kanagala
iOS Development Techdegree Student 617 Points
Arun Kanagala
.a{fill-rule:evenodd;}techdegree
Arun Kanagala
iOS Development Techdegree Student 617 Points

Gotcha !