figure13

scorebot_production=# select rt.name as team, count(*) as self_steals 
                      from redemptions r, instances i, teams rt, tokens t
                      where r.token_id = t.id and t.instance_id = i.id and i.team_id = r.team_id
                            and r.team_id = rt.id
                      group by rt.name
                      order by self_steals desc;  
           team           | self_steals 
--------------------------+-------------
 men in black hats        |         270
 blue lotus               |          41
 raon_ASRT                |          36
 shell corp               |          16
 WOWHacker-BI0S           |          13
 APT8                     |          13
 pwnies                   |           6
 clgt                     |           5
 more smoked leet chicken |           3
 shellphish               |           3
 Alternatives             |           2
 Samurai                  |           2
 PPP                      |           2
 pwningyeti               |           1
(14 rows)