League Table Points

A win is worth 3 points, a draw 1 and a loss 0. Return each team and its total points, ordered by points descending and then by team name.

Table schema

Matches(id INT PRIMARY KEY, home VARCHAR(10), away VARCHAR(10), home_goals INT, away_goals INT)

Sample data

id | home | away | home_goals | away_goals
1 | A | B | 2 | 1
2 | B | C | 0 | 0
3 | C | A | 1 | 3