figure18

scorebot_production=# select rt.name as team, s.name as svc, count(*) as steals
                      from redemptions r, instances i, teams rt, services s, tokens t
                      where r.token_id = t.id and t.instance_id = i.id and s.id = i.service_id
                            and r.team_id = rt.id and r.team_id != i.team_id
                      group by rt.name, s.name
                      order by rt.name asc, s.name asc;
           team            |   svc    | steals 
---------------------------+----------+--------
 9447                      | atmail   |    757
 Alternatives              | atmail   |    726
 Alternatives              | avoir    |    106
 Alternatives              | bookworm |    247
 Alternatives              | lonetuna |      2
 Alternatives              | trouver  |     14
 APT8                      | atmail   |     20
 APT8                      | lonetuna |     16
 blue lotus                | atmail   |    797
 blue lotus                | avoir    |    121
 blue lotus                | bookworm |    182
 clgt                      | atmail   |    295
 clgt                      | bookworm |     91
 men in black hats         | atmail   |    705
 men in black hats         | bookworm |    320
 men in black hats         | lonetuna |     53
 men in black hats         | reeses   |    334
 men in black hats         | trouver  |    182
 more smoked leet chicken  | atmail   |    959
 more smoked leet chicken  | avoir    |    195
 more smoked leet chicken  | bookworm |    304
 more smoked leet chicken  | lonetuna |     71
 more smoked leet chicken  | reeses   |    132
 more smoked leet chicken  | trouver  |     19
 PPP                       | atmail   |    864
 PPP                       | avoir    |    365
 PPP                       | bookworm |    181
 PPP                       | lonetuna |    581
 PPP                       | reeses   |    377
 PPP                       | trouver  |    157
 pwnies                    | atmail   |    536
 pwningyeti                | atmail   |    688
 pwningyeti                | bookworm |    153
 raon_ASRT                 | atmail   |    800
 raon_ASRT                 | avoir    |    304
 raon_ASRT                 | bookworm |    350
 raon_ASRT                 | lonetuna |     24
 raon_ASRT                 | reeses   |    140
 raon_ASRT                 | trouver  |    107
 Robot Mafia               | atmail   |    148
 Robot Mafia               | bookworm |     23
 routards                  | atmail   |    506
 routards                  | avoir    |    132
 routards                  | bookworm |    133
 routards                  | trouver  |    180
 Samurai                   | atmail   |    292
 Samurai                   | avoir    |    119
 Samurai                   | bookworm |    219
 Samurai                   | lonetuna |     30
 Samurai                   | trouver  |    125
 shell corp                | atmail   |    537
 shell corp                | avoir    |     52
 shell corp                | bookworm |     99
 shellphish                | atmail   |    893
 shellphish                | avoir    |    139
 shellphish                | bookworm |    187
 shellphish                | trouver  |      3
 sutegoma2                 | atmail   |    637
 sutegoma2                 | lonetuna |      8
 sutegoma2                 | trouver  |     16
 [Technopandas]            | atmail   |    541
 The European Nopsled Team | atmail   |    664
 The European Nopsled Team | avoir    |     13
 The European Nopsled Team | bookworm |     43
 The European Nopsled Team | lonetuna |     11
 WOWHacker-BI0S            | atmail   |    297
 WOWHacker-BI0S            | bookworm |    145
(67 rows)


scorebot_production=# select s.name as svc, rt.name as team, count(*) as steals from redemptions r, instances i, teams rt, services s, tokens t where r.token_id = t.id and t.instance_id = i.id and s.id = i.service_id and r.team_id = rt.id and r.team_id != i.team_id group by s.name, rt.name order by s.name asc, count(*) desc;
   svc    |           team            | steals 
----------+---------------------------+--------
 atmail   | more smoked leet chicken  |    959
 atmail   | shellphish                |    893
 atmail   | PPP                       |    864
 atmail   | raon_ASRT                 |    800
 atmail   | blue lotus                |    797
 atmail   | 9447                      |    757
 atmail   | Alternatives              |    726
 atmail   | men in black hats         |    705
 atmail   | pwningyeti                |    688
 atmail   | The European Nopsled Team |    664
 atmail   | sutegoma2                 |    637
 atmail   | [Technopandas]            |    541
 atmail   | shell corp                |    537
 atmail   | pwnies                    |    536
 atmail   | routards                  |    506
 atmail   | WOWHacker-BI0S            |    297
 atmail   | clgt                      |    295
 atmail   | Samurai                   |    292
 atmail   | Robot Mafia               |    148
 atmail   | APT8                      |     20
 avoir    | PPP                       |    365
 avoir    | raon_ASRT                 |    304
 avoir    | more smoked leet chicken  |    195
 avoir    | shellphish                |    139
 avoir    | routards                  |    132
 avoir    | blue lotus                |    121
 avoir    | Samurai                   |    119
 avoir    | Alternatives              |    106
 avoir    | shell corp                |     52
 avoir    | The European Nopsled Team |     13
 bookworm | raon_ASRT                 |    350
 bookworm | men in black hats         |    320
 bookworm | more smoked leet chicken  |    304
 bookworm | Alternatives              |    247
 bookworm | Samurai                   |    219
 bookworm | shellphish                |    187
 bookworm | blue lotus                |    182
 bookworm | PPP                       |    181
 bookworm | pwningyeti                |    153
 bookworm | WOWHacker-BI0S            |    145
 bookworm | routards                  |    133
 bookworm | shell corp                |     99
 bookworm | clgt                      |     91
 bookworm | The European Nopsled Team |     43
 bookworm | Robot Mafia               |     23
 lonetuna | PPP                       |    581
 lonetuna | more smoked leet chicken  |     71
 lonetuna | men in black hats         |     53
 lonetuna | Samurai                   |     30
 lonetuna | raon_ASRT                 |     24
 lonetuna | APT8                      |     16
 lonetuna | The European Nopsled Team |     11
 lonetuna | sutegoma2                 |      8
 lonetuna | Alternatives              |      2
 reeses   | PPP                       |    377
 reeses   | men in black hats         |    334
 reeses   | raon_ASRT                 |    140
 reeses   | more smoked leet chicken  |    132
 trouver  | men in black hats         |    182
 trouver  | routards                  |    180
 trouver  | PPP                       |    157
 trouver  | Samurai                   |    125
 trouver  | raon_ASRT                 |    107
 trouver  | more smoked leet chicken  |     19
 trouver  | sutegoma2                 |     16
 trouver  | Alternatives              |     14
 trouver  | shellphish                |      3
(67 rows)