Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.
Ammar Fatihallah
7,417 PointsError in query?
My query:
select * from results where home_team == 'Hessle' and away_score > 18;
Message:
Bummer! Did you select from the results table?
Did I do anything wrong in the query
1 Answer
Steven Parker
215,939 PointsIn SQL, an equality comparison operator is just a single "=".
Other than that, I'd probably need to see the original instructions to give a more complete answer. It's always helpful to provide a link the course page you are working with.
Ammar Fatihallah
7,417 PointsAmmar Fatihallah
7,417 Pointshttps://teamtreehouse.com/library/sql-basics/finding-the-data-you-want/filtering-on-more-than-one-condition-2
Steven Parker
215,939 PointsSteven Parker
215,939 PointsNow that I can see the challenge, I notice the instructions say to find "where "Hessle" was playing away as the away team", so you'll need to check a different column in addition to fixing the operator.