Unit counts by faction and role

How many units each faction has, split by role.

Custom SQL query returning 20 rows (hide) 

SELECT faction, role, COUNT(*) as n FROM units GROUP BY faction, role ORDER BY faction, role

Edit SQL

This data as json, CSV

factionrolen
Atlantean human 15
Atlantean myth 16
Aztec hero 5
Aztec human 13
Aztec myth 14
Chinese hero 9
Chinese human 28
Chinese myth 25
Egyptian hero 3
Egyptian human 18
Egyptian myth 13
Greek hero 18
Greek human 18
Greek myth 18
Japanese hero 6
Japanese human 12
Japanese myth 14
Norse hero 4
Norse human 11
Norse myth 17