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
Zach Tan
2,970 PointsI have answer the exercise with all the columns names included and I still got an error of missing column. Please help.
SELECT id, home_team, home_score, away_team, away_score, played_on FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01";
Zach Tan
2,970 PointsBelow is the question of my quiz:
Challenge Task 1 of 1
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".
1 Answer
Steven Parker
231,261 Points
I think they want you to represent all columns as * instead of naming them explicitly.
Other than that, it looks good.
Jason Anders
Treehouse Moderator 145,860 PointsJason Anders
Treehouse Moderator 145,860 PointsYou will need to resubmit your question and link it directly to the challenge/quiz. You do this by clicking on the "Get Help" button and follow the instructions. This way we are able to reference what it is exactly is needed to be done. Make sure "Attach my code to this post." is check so we may see your complete code.
Thanks.