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

Stu Parker
Stu Parker
4,814 Points
Posted by Stu Parker
Stu Parker
4,814 Points

Having problem with Sql section 3

I am trying submit the following code on 2nd part

SELECT * FROM results WHERE home_score < 10;

This is virtually the same as one before. However,despite the preview showing the result(the home team , Marlborough scores 6 against hassle,18 on the 2015-10-10).. I get an error on submission asking me if I queried from 'results' table, all the while dodging my points for.incorrect submissions.

1 Answer

Joel Bardsley
Joel Bardsley
31,249 Points
Joel Bardsley
Joel Bardsley
31,249 Points

Hi Stu,

You've got the right idea, but it's best to double check the wording of the challenge sometimes when all else fails:

Find all results where the away team's score is lower than 10.

Your attempted query is searching for results where the home team's score is lower than 10.

The feedback message you're receiving from the challenge isn't particularly helpful so it's important at times not to trust it in case it sends you down the wrong path for correcting your answer.