-
-
Save ctfaddict/e9f1d633aafc8bc88c62 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
scorebot_production=# select rt.name as team, count(*) steals | |
from redemptions r, instances i, teams rt, tokens t | |
where r.token_id = t.id and t.instance_id = i.id and rt.id = r.team_id | |
and r.team_id != i.team_id | |
group by rt.name | |
order by count(*) desc; | |
team | steals | |
---------------------------+-------- | |
PPP | 2525 | |
raon_ASRT | 1725 | |
more smoked leet chicken | 1680 | |
men in black hats | 1594 | |
shellphish | 1222 | |
blue lotus | 1100 | |
Alternatives | 1095 | |
routards | 951 | |
pwningyeti | 841 | |
Samurai | 785 | |
9447 | 757 | |
The European Nopsled Team | 731 | |
shell corp | 688 | |
sutegoma2 | 661 | |
[Technopandas] | 541 | |
pwnies | 536 | |
WOWHacker-BI0S | 442 | |
clgt | 386 | |
Robot Mafia | 171 | |
APT8 | 36 | |
(20 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment