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 Tyric Foreman
Tyric Foreman
1,398 Points

when youre double checking your work and youre still stuck on a task, how do you get the answer to move along ?

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 their score was above 18 points.

select * from results where home_team and home_score > 18;

above is the code ive written and its telling me im missing " = "

1 Answer

Steven Parker
Steven Parker
229,784 Points
Steven Parker
Steven Parker
229,784 Points

You never have to finish a quiz to move along. Just look at the progress bar near the top of the page, the dot that represents the current page will have a circle around it. Click on the next dot to the right to move on.

If you're on the last lesson of a stage, you can click on the course title in the upper left to go to the course index. From there, you can select the first lesson of the next stage and move on that way.

But for this query, the WHERE clause names "home_team" but don't compare it to anything. The missing "=" will be used as part of the comparison. Also, notice that the instructions talk about the "away team" and not the home team.