Databases SQL Basics Finding the Data You Want Filtering by Comparing Values

Problem with code.

We have a database that runs a sports team's website. In the results table we have the columns id, home_team, home_score, away_team, away_score, played_on. Find all results where the home team's score is above 12.

How do I solve this?

1 Answer

Gabriel Pierce-Lackey
Gabriel Pierce-Lackey
11,002 Points
SELECT * FROM results WHERE home_score > 12;