figure22

scorebot_production=# select t.name as team, count(*) as total
                      from captures c, redemptions r, teams t, tokens k, instances i
                      where c.redemption_id = r.id and i.team_id = t.id and r.token_id = k.id
                            and k.instance_id = i.id
                      group by t.name
                      order by total desc;
           team            | total 
---------------------------+-------
 men in black hats         |  5666
 blue lotus                |  3740
 Alternatives              |  3105
 9447                      |  2751
 more smoked leet chicken  |  2707
 shellphish                |  2648
 APT8                      |  2483
 pwnies                    |  2099
 raon_ASRT                 |  2051
 pwningyeti                |  1949
 The European Nopsled Team |  1895
 Samurai                   |  1879
 [Technopandas]            |  1837
 WOWHacker-BI0S            |  1825
 clgt                      |  1465
 Robot Mafia               |  1456
 routards                  |  1402
 PPP                       |  1347
 sutegoma2                 |  1336
 shell corp                |  1039
(20 rows)