Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure11 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select s.name, count(*), count(*) * 19 as flags_lost
from availabilities a, instances i, services s
where a.instance_id = i.id and i.service_id = s.id and a.status != 0
group by s.name
order by s.name asc;
name | count | flags_lost
----------+-------+------------
atmail | 607 | 11533
avoir | 216 | 4104
bookworm | 177 | 3363
lonetuna | 1564 | 29716
reeses | 328 | 6232
trouver | 215 | 4085
(6 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment