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 Gabriel E
Gabriel E
8,916 Points

What else do I need to do on this challenge?

Title basically sums it up. I'm not including or 'selecting' all columns as the editor is saying to me. What else do I have to do? Thanks in advance!

Gabriel E
Gabriel E
8,916 Points

Ok, so it's SQL Basics, and the challenge is Filtering On More Than One Condition. Thanks! I think this is all you'll need and I'm having trouble on both two tasks. Here is my code for Task 1 so far: SELECT away_team FROM results WHERE away_score > "18";

1 Answer

Brendan Whiting
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
Brendan Whiting
.a{fill-rule:evenodd;}techdegree seal-36
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points

In task 1 of 2 you need to test for both conditions, not just 1, and they want you to select all the columns:

SELECT * FROM results WHERE away_team = "Hessle" AND away_score > 18;

Let me know if you need help with task 2 of 2;