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

Zach Tan
Zach Tan
2,970 Points

I 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";

Jason Anders
Jason Anders
Treehouse Moderator 145,858 Points

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

:dizzy:

Zach Tan
Zach Tan
2,970 Points

Below 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
Steven Parker
229,921 Points

:point_right: I think they want you to represent all columns as * instead of naming them explicitly.

Other than that, it looks good. :+1: