Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure2 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select t.id,t.name,count(*) from teams t,flags f
where f.team_id = t.id
group by t.id,t.name
order by count(*) desc;
id | name | count
----+-------------------------------+-------
2 | PPP | 15002
14 | men in black hats | 7924
21 | Legitimate Business Syndicate | 7628
4 | raon_ASRT | 7107
7 | more smoked leet chicken | 4160
9 | routards | 2503
16 | sutegoma2 | 1540
11 | shellphish | 1223
19 | Alternatives | 1095
6 | The European Nopsled Team | 859
13 | 9447 | 506
8 | blue lotus | 441
1 | Samurai | 12
(13 rows)(
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment