figure10

scorebot_production=# select t.name, s.name, count(*), count(*) * 19 as flags_lost
                      from availabilities a, instances i, teams t, services s
                      where a.instance_id = i.id and i.team_id = t.id and i.service_id = s.id and a.status != 0
                      group by t.name, s.name
                      order by t.name asc, s.name asc;
             name              |   name   | count | flags_lost 
-------------------------------+----------+-------+------------
 9447                          | atmail   |    17 |        323
 9447                          | avoir    |    30 |        570
 9447                          | bookworm |     3 |         57
 9447                          | lonetuna |    32 |        608
 9447                          | reeses   |    25 |        475
 9447                          | trouver  |     6 |        114
 Alternatives                  | atmail   |    13 |        247
 Alternatives                  | avoir    |     5 |         95
 Alternatives                  | bookworm |     5 |         95
 Alternatives                  | lonetuna |    31 |        589
 Alternatives                  | reeses   |    12 |        228
 Alternatives                  | trouver  |     5 |         95
 APT8                          | atmail   |    51 |        969
 APT8                          | avoir    |    13 |        247
 APT8                          | bookworm |    12 |        228
 APT8                          | lonetuna |    56 |       1064
 APT8                          | reeses   |    23 |        437
 APT8                          | trouver  |    12 |        228
 blue lotus                    | atmail   |     9 |        171
 blue lotus                    | avoir    |     2 |         38
 blue lotus                    | bookworm |     1 |         19
 blue lotus                    | lonetuna |    40 |        760
 blue lotus                    | reeses   |    22 |        418
 blue lotus                    | trouver  |     2 |         38
 clgt                          | atmail   |    55 |       1045
 clgt                          | avoir    |    28 |        532
 clgt                          | bookworm |    19 |        361
 clgt                          | lonetuna |   106 |       2014
 clgt                          | reeses   |    19 |        361
 clgt                          | trouver  |    26 |        494
 Legitimate Business Syndicate | atmail   |     1 |         19
 Legitimate Business Syndicate | bookworm |     1 |         19
 Legitimate Business Syndicate | lonetuna |    14 |        266
 men in black hats             | atmail   |     4 |         76
 men in black hats             | avoir    |     3 |         57
 men in black hats             | lonetuna |    66 |       1254
 men in black hats             | reeses   |     8 |        152
 men in black hats             | trouver  |     5 |         95
 more smoked leet chicken      | atmail   |    23 |        437
 more smoked leet chicken      | avoir    |     6 |        114
 more smoked leet chicken      | bookworm |     1 |         19
 more smoked leet chicken      | lonetuna |    10 |        190
 more smoked leet chicken      | reeses   |     5 |         95
 more smoked leet chicken      | trouver  |     5 |         95
 PPP                           | atmail   |     4 |         76
 PPP                           | avoir    |     2 |         38
 PPP                           | bookworm |     3 |         57
 PPP                           | lonetuna |    45 |        855
 PPP                           | reeses   |     9 |        171
 PPP                           | trouver  |     2 |         38
 pwnies                        | atmail   |    10 |        190
 pwnies                        | avoir    |    13 |        247
 pwnies                        | bookworm |     4 |         76
 pwnies                        | lonetuna |   141 |       2679
 pwnies                        | reeses   |    18 |        342
 pwnies                        | trouver  |     3 |         57
 pwningyeti                    | atmail   |    27 |        513
 pwningyeti                    | avoir    |    14 |        266
 pwningyeti                    | bookworm |    18 |        342
 pwningyeti                    | lonetuna |   124 |       2356
 pwningyeti                    | reeses   |    13 |        247
 pwningyeti                    | trouver  |    12 |        228
 raon_ASRT                     | atmail   |    41 |        779
 raon_ASRT                     | avoir    |     3 |         57
 raon_ASRT                     | bookworm |     2 |         38
 raon_ASRT                     | lonetuna |    38 |        722
 raon_ASRT                     | reeses   |    14 |        266
 raon_ASRT                     | trouver  |     3 |         57
 Robot Mafia                   | atmail   |    30 |        570
 Robot Mafia                   | avoir    |    36 |        684
 Robot Mafia                   | bookworm |    47 |        893
 Robot Mafia                   | lonetuna |   150 |       2850
 Robot Mafia                   | reeses   |    36 |        684
 Robot Mafia                   | trouver  |    40 |        760
 routards                      | atmail   |     8 |        152
 routards                      | avoir    |     4 |         76
 routards                      | bookworm |     1 |         19
 routards                      | lonetuna |    34 |        646
 routards                      | reeses   |    22 |        418
 routards                      | trouver  |    16 |        304
 Samurai                       | atmail   |    61 |       1159
 Samurai                       | avoir    |     7 |        133
 Samurai                       | bookworm |     4 |         76
 Samurai                       | lonetuna |   104 |       1976
 Samurai                       | reeses   |    15 |        285
 Samurai                       | trouver  |     7 |        133
 shell corp                    | atmail   |    78 |       1482
 shell corp                    | avoir    |     4 |         76
 shell corp                    | bookworm |     6 |        114
 shell corp                    | lonetuna |   106 |       2014
 shell corp                    | reeses   |    14 |        266
 shell corp                    | trouver  |     5 |         95
 shellphish                    | atmail   |    17 |        323
 shellphish                    | avoir    |    19 |        361
 shellphish                    | bookworm |     3 |         57
 shellphish                    | lonetuna |    60 |       1140
 shellphish                    | reeses   |     8 |        152
 shellphish                    | trouver  |    14 |        266
 sutegoma2                     | atmail   |     5 |         95
 sutegoma2                     | avoir    |     6 |        114
 sutegoma2                     | bookworm |    27 |        513
 sutegoma2                     | lonetuna |    75 |       1425
 sutegoma2                     | reeses   |    15 |        285
 sutegoma2                     | trouver  |    25 |        475
 [Technopandas]                | atmail   |    61 |       1159
 [Technopandas]                | avoir    |     7 |        133
 [Technopandas]                | bookworm |    18 |        342
 [Technopandas]                | lonetuna |   129 |       2451
 [Technopandas]                | reeses   |    11 |        209
 [Technopandas]                | trouver  |     6 |        114
 The European Nopsled Team     | atmail   |    20 |        380
 The European Nopsled Team     | avoir    |     4 |         76
 The European Nopsled Team     | lonetuna |   109 |       2071
 The European Nopsled Team     | reeses   |    25 |        475
 The European Nopsled Team     | trouver  |    12 |        228
 WOWHacker-BI0S                | atmail   |    72 |       1368
 WOWHacker-BI0S                | avoir    |    10 |        190
 WOWHacker-BI0S                | bookworm |     2 |         38
 WOWHacker-BI0S                | lonetuna |    94 |       1786
 WOWHacker-BI0S                | reeses   |    14 |        266
 WOWHacker-BI0S                | trouver  |     9 |        171
(121 rows)