figure9

scorebot_production=# select t.name, count(*), count(*) * 19 as flags_lost 
                      from availabilities a, instances i, teams t
                      where a.instance_id = i.id and i.team_id = t.id and a.status != 0
                      group by t.name
                      order by count(*) desc;
             name              | count | flags_lost 
-------------------------------+-------+------------
 Robot Mafia                   |   339 |       6441
 clgt                          |   253 |       4807
 [Technopandas]                |   232 |       4408
 shell corp                    |   213 |       4047
 pwningyeti                    |   208 |       3952
 WOWHacker-BI0S                |   201 |       3819
 Samurai                       |   198 |       3762
 pwnies                        |   189 |       3591
 The European Nopsled Team     |   170 |       3230
 APT8                          |   167 |       3173
 sutegoma2                     |   153 |       2907
 shellphish                    |   121 |       2299
 9447                          |   113 |       2147
 raon_ASRT                     |   101 |       1919
 men in black hats             |    86 |       1634
 routards                      |    85 |       1615
 blue lotus                    |    76 |       1444
 Alternatives                  |    71 |       1349
 PPP                           |    65 |       1235
 more smoked leet chicken      |    50 |        950
 Legitimate Business Syndicate |    16 |        304
(21 rows)