figure28

scorebot_production=# select t.name, a.round_id, s.name, a.status from availabilities a, instances i, services s, teams t
                      where (a.round_id=253 or a.round_id=254) and a.instance_id=i.id and i.team_id = t.id 
                            and t.name like 'men%' and i.service_id = s.id
                      order by a.round_id asc;
       name        | round_id |   name   | status 
-------------------+----------+----------+--------
 men in black hats |      253 | atmail   |      0
 men in black hats |      253 | bookworm |      0
 men in black hats |      253 | lonetuna |      0
 men in black hats |      253 | reeses   |      0
 men in black hats |      253 | trouver  |      0
 men in black hats |      253 | avoir    |      0
 men in black hats |      254 | trouver  |      0
 men in black hats |      254 | atmail   |      0
 men in black hats |      254 | reeses   |      0
 men in black hats |      254 | bookworm |      0
 men in black hats |      254 | avoir    |     14
 men in black hats |      254 | lonetuna |      0
(12 rows)

scorebot_production=# select t.name, a.round_id, s.name, a.status from availabilities a, instances i, services s, teams t
         where (a.round_id=253 or a.round_id=254) and a.instance_id=i.id and i.team_id = t.id and t.name like '%phish'
               and i.service_id = s.id and s.name like 'av%'
         order by a.round_id asc;
    name    | round_id | name  | status 
------------+----------+-------+--------
 shellphish |      253 | avoir |      0
 shellphish |      254 | avoir |      0
(2 rows)