Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure20 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select t.name as team, count(*) as total
from captures c, redemptions r, teams t
where c.redemption_id = r.id and r.team_id = t.id
group by t.name
order by total desc;
team | total
---------------------------+-------
PPP | 12883
men in black hats | 9905
raon_ASRT | 6569
more smoked leet chicken | 3713
shellphish | 1508
Alternatives | 1191
blue lotus | 1179
sutegoma2 | 1041
9447 | 1005
pwnies | 840
The European Nopsled Team | 777
routards | 776
Samurai | 712
pwningyeti | 703
shell corp | 611
WOWHacker-BI0S | 454
[Technopandas] | 370
clgt | 276
Robot Mafia | 99
APT8 | 68
(20 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment