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 Kevin Bunce
Kevin Bunce
353 Points

I keep using the 'results' table name in my query answers and getting wrong answer prompts saying I didn't use 'results'

In SQL Basics quizzes - I'm 99% sure I'm answering the quiz questions correctly and yet there is no way to move forward if it is marked incorrect. It's very frustrating.

AJ Salmon
AJ Salmon
5,675 Points
AJ Salmon
AJ Salmon
5,675 Points

Could you either link or name the quiz so I can better see what you mean?

Kevin Bunce
Kevin Bunce
353 Points

https://teamtreehouse.com/library/sql-basics/finding-the-data-you-want/filtering-on-more-than-one-condition-2

AJ Salmon
AJ Salmon
5,675 Points
AJ Salmon
AJ Salmon
5,675 Points

Does this code not work for you? 

SELECT * FROM results WHERE away_team = "Hessle" AND away_score > 18
Kevin Bunce
Kevin Bunce
353 Points

It's working for me now - I swear I'm using the exact same syntax. It must be because I'm a QA guy - I bring out the bugs in everything ;)

AJ Salmon
AJ Salmon
5,675 Points
AJ Salmon
AJ Salmon
5,675 Points

Haha, I'm glad it's working, happy coding dude :)