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

Jackson Hyland
Jackson Hyland
4,920 Points
Posted by Jackson Hyland
Jackson Hyland
4,920 Points

What am i doing wrong? please help

I'm doing the SQL Basics challenge "filtering by comparing values". task two is pretty much the same as task one but i keep getting it wrong.. Bummer! Did you select from the results table?

i MUST be missing something unless it's bugged out? any advice would be great thanks.

Jackson Hyland
Jackson Hyland
4,920 Points
Jackson Hyland
Jackson Hyland
4,920 Points

never mind, i was mislead by the "Did you select from the results table?". i actually was comparing wrong value.

Zachary Wheeler
Zachary Wheeler
1,157 Points
Zachary Wheeler
Zachary Wheeler
1,157 Points

SELECT * FROM results WHERE home_team = "Hessle" AND home_score > 18;

I am not sure how to fix this. It's giving me the same error you had, but i'm not sure which part is wrong.

1 Answer

Steven Parker
Steven Parker
231,271 Points
Steven Parker
Steven Parker
231,271 Points

Congrats on resolving your issue!

And for Zachary Wheeler:
You're on a different challenge, but yours says, "Find all the matches in the results table where "Hessle" was playing away as the away team and their score was above 18 points."

So your query is looking at the wrong columns. You want the "away_..." columns instead of the "home_..." columns.