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 Alexander Salako
Alexander Salako
360 Points

find all users

I don't know what other column to add to the query.

Steven Parker
Steven Parker
241,811 Points
Steven Parker
Steven Parker
241,811 Points

Please show the query, and provide a link to the course page you are working with.

Alexander Salako
Alexander Salako
360 Points

SELECT id, home_team, home_score, away_team, away_score, played_on FROM results WHERE "Hessle" = away_team AND played_on = "2015-10-01" OR "Hessle" = away_team 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

1 Answer

Steven Parker
Steven Parker
241,811 Points
Steven Parker
Steven Parker
241,811 Points

Instead of entering columns by name, try the "*" shorthand to represent "all columns".

Also, you can simplify the WHERE clause by using the ">=" operator to test for "on or after" a specific date.

Alexander Salako
Alexander Salako
360 Points

Thank you!