figure20

scorebot_production=# select t.name as team, count(*) as total
                      from captures c, redemptions r, teams t
                      where c.redemption_id = r.id and r.team_id = t.id
                      group by t.name
                      order by total desc;
           team            | total 
---------------------------+-------
 PPP                       | 12883
 men in black hats         |  9905
 raon_ASRT                 |  6569
 more smoked leet chicken  |  3713
 shellphish                |  1508
 Alternatives              |  1191
 blue lotus                |  1179
 sutegoma2                 |  1041
 9447                      |  1005
 pwnies                    |   840
 The European Nopsled Team |   777
 routards                  |   776
 Samurai                   |   712
 pwningyeti                |   703
 shell corp                |   611
 WOWHacker-BI0S            |   454
 [Technopandas]            |   370
 clgt                      |   276
 Robot Mafia               |    99
 APT8                      |    68
(20 rows)