account
challenge
contact
credit
hacker
links
stat
todo
wtf

Top Hackers
alucardo 354 points 100.00%
Anonr 354 points 100.00%
saiwa 354 points 100.00%
thefinder 354 points 100.00%
neoxquick 344 points 97.18%
livinskull 336 points 94.92%
tehron 335 points 94.63%
Akorlith 325 points 91.81%
rubiya 323 points 91.24%
madbat2 320 points 90.40%

New Hackers
GetVaMage : What's that say? I
fish : Calculating the Combination
bey0nd : A curious escape
Shadokin : What's that say? IV
suffering : A curious escape
pako : Selecting the right OS

Partner Sites
Halls of Valhalla
Additional Challenge Sites
pwnable.kr with 70 challenges.
Revolution Elite with 195 challenges.
247CTF with 54 challenges.
hax.tor.hu with 50 challenges.
Reversing.Kr with 27 challenges.
Updated on 11/28/20 5:43:13 AM UTC
It's only a game!

Research harder

Who's the custodian?

You have three tables in a PostgreSQL database.
  • users
  • roles
  • user_roles
Produce a query that generates two columns.

  1. "Custodian" : Contains boolean "true" when the person's role is "Janitor", "false" in all other instances.
  2. "Person" : Contains the user's name, sorted ascending.

The columns in your ResultSet MUST be named exactly, in this order:
  • Custodian
  • Person


Good Luck!
Enter your query below and click submit.




Who's beaten this one?
Pseudo
  Pass

There are currently 90 challenges, with a maximum possible value of 354 points.

New Challenges
Rumplestiltskin
Unusual Translation
Hashed II
Beep Beep
JSON and the Argonauts III
JSON and the Argonauts II
JSON and the Argonauts I

Most Popular Challenges
What's that say? I
A curious escape
Computer Talk
Base 8^2
What's that say? III
I came, I saw, I encrypted
What goes there?

2 hackers solved 2 challenges this week
What's that say? I by GetVaMage
Classic Cipher Play I by xaav

View more stats

Member of The Internet Defense League

Care and feeding instructions