1-v-1 win rates by creature

How often each creature wins its 1-v-1 duels.

Custom SQL query returning 18 rows (hide) 

SELECT name, SUM(wins) AS wins, SUM(battles) AS battles, ROUND(SUM(wins) * 100.0 / SUM(battles), 1) AS win_pct FROM (SELECT left_name AS name, SUM(CASE WHEN winner = 'left' THEN 1 ELSE 0 END) AS wins, COUNT(*) AS battles FROM battles_1v1 GROUP BY left_name UNION ALL SELECT right_name, SUM(CASE WHEN winner = 'right' THEN 1 ELSE 0 END), COUNT(*) FROM battles_1v1 GROUP BY right_name) GROUP BY name ORDER BY win_pct DESC

Edit SQL

This data as json, CSV

namewinsbattleswin_pct
Sprite 8 8 100.0
Pikeman 8 8 100.0
Centaur Captain 7 8 87.5
Centaur 7 8 87.5
Halberdier 6 8 75.0
Troglodyte 5 8 62.5
Gnoll 5 8 62.5
Goblin 4 8 50.0
Gnoll Marauder 4 8 50.0
Skeleton 3 8 37.5
Pixie 3 8 37.5
Master Gremlin 3 8 37.5
Infernal Troglodyte 3 8 37.5
Skeleton Warrior 2 8 25.0
Hobgoblin 2 8 25.0
Imp 1 8 12.5
Familiar 1 8 12.5
Gremlin 0 8 0.0