Databases SQL Basics Finding the Data You Want Filtering on More than One Condition

Cliona Dowling
Cliona Dowling
559 Points
Posted by Cliona Dowling
Cliona Dowling
559 Points

What is incorrect in this query:

What is incorrect in this query: SELECT * FROM results WHERE away_team = "Hessle" AND away_score > 12;

1 Answer

Steven Parker
Steven Parker
176,294 Points
Steven Parker
Steven Parker
176,294 Points

The challenge asks "Find all the matches in the results table where "Hessle" was playing away as the away team and their score was above 18 points."

So the issue is with the number of points you are comparing to (perhaps it was just a typo?).