Head-to-Head Record

For every pair of players who have met, return the player names (alphabetically ordered pair) and how many games each won against the other. Order by the pair.

Table schema

Games(id INT PRIMARY KEY, winner VARCHAR(10), loser VARCHAR(10))

Sample data

id | winner | loser
1 | A | B
2 | A | B
3 | B | A