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
Posted by Zach Tan
Zach Tan
2,970 Points

SQL Basics

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

Zach Tan
Zach Tan
2,970 Points
Zach Tan
Zach Tan
2,970 Points

Below is the code that I have used.

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

id home_team home_score away_team away_score played_on 4 Mosborough 6 Hessle 18 2015-10-10

3 Answers

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

SQLite will accept either kind of quotes (" or ').

You are correct that the challenge expects all columns to be represented by * instead of naming them individually.

Christopher Earle
PLUS
Christopher Earle
Courses Plus Student 22,340 Points
Christopher Earle
Christopher Earle
Courses Plus Student 22,340 Points

Hi Zach,

If I remember correctly, SQL date criteria uses single instead of double quotes. For example,

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

Zach Tan
Zach Tan
2,970 Points
Zach Tan
Zach Tan
2,970 Points

Hi Christopher,

Thanks a lot for your answer. I have find out the correct answer for the quiz.

I have to use SELECT * instead of SELECT id, home_team etc to get the correct answer even though I have include all the columns. Thanks alot for your help.