account
challenge
contact
credit
hacker
links
stat
todo
wtf

Top Hackers
alucardo 354 points 100.00%
saiwa 354 points 100.00%
thefinder 354 points 100.00%
Anonr 350 points 98.87%
neoxquick 344 points 97.18%
tehron 330 points 93.22%
madbat2 320 points 90.40%
Akorlith 319 points 90.11%
rubiya 319 points 90.11%
Holographic 317 points 89.55%

New Hackers
alanzee : I came, I saw, I encrypted
drewbie411 : What's that say? I
Achidutzu : What's that say? V
L3arn3r : Calculating the Combination
Gypsy : Play Fair!
bluehelmet : A curious escape

Partner Sites
Halls of Valhalla
Additional Challenge Sites
wargame.kr with 35 challenges.
try to decrypt with 23 challenges.
TDHack with 202 challenges.
Hacking-Challenges with 145 challenges.
SuNiNaTaS with 32 challenges.
Updated on 08/15/18 8:01:24 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?

3 hackers solved 67 challenges this week
Templar Decoder Ring by Achidutzu
Crackerjack Encryption by Achidutzu
Base 8^2 by deurus
Real Men of Genius I by deurus
I came, I saw, I encrypted by alanzee
Calculating the Combination by alanzee
Cartoon Arithmetic by alanzee
Logic Cubed by alanzee
What goes there? by alanzee
What's that say? I by alanzee
What's that say? III by alanzee
Computer Talk by alanzee
A curious escape by alanzee
Base 8^2 by alanzee
What's that say? IV by alanzee
What's that say? V by alanzee
Hashed by alanzee
Where ya coming from? by alanzee
Hashed II by alanzee
Javascript Entertainment by alanzee
What's that say? II by alanzee
Malformed by alanzee
Selecting the right OS by alanzee
Adjoined by alanzee
Inserted by alanzee
Terminal Hacking by alanzee
Repetitive math by alanzee
New wave gibberish by alanzee
Return to sender by alanzee
A different method by alanzee
Accessing routes by alanzee
Hop Skip and Jump by alanzee
Oink Oink by alanzee
On the fence by alanzee
The tools are out there by alanzee
Templar Decoder Ring by alanzee
Play Fair! by alanzee
Julius's Key by alanzee
Encoding is not Encryption by alanzee
Real Men of Genius I by alanzee
Real Men of Genius II by alanzee
Pass, Fail or Skipped? by alanzee
Speak up by alanzee
Who's the custodian? by alanzee
Craptcha I by alanzee
Calculate quickly by alanzee
Making words out of numbers by alanzee
Parse it fast by alanzee
Crackerjack Encryption by alanzee
Reversing the application I by alanzee
Reversing the application II by alanzee
Reversing the application III by alanzee
Digging Deeper by alanzee
Logjam Disarray by alanzee
Poking Around II by alanzee
Poking Around I by alanzee
Poking Around IV by alanzee
Poking Around V by alanzee
Poking Around VI by alanzee
Mixing up the classics by alanzee
Classic Cipher Play II by alanzee
Craptcha III by alanzee
Wheel of Fortune by alanzee
Pin-up Steganography II by alanzee
Message for you sir! by alanzee
More classical review by alanzee
Thin Air by alanzee

View more stats

Member of The Internet Defense League

Care and feeding instructions