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
Anone : Rumplestiltskin
michjewastaken : What goes there?
codejunkie : What's that say? III
Turtles : What's that say? I
hackelmo : What's that say? V
carfty : Computer Talk

Partner Sites
Halls of Valhalla
Additional Challenge Sites
RingZer0 Team Online CTF with 325 challenges.
OverTheWire.org with 174 challenges.
Tasteless with 21 challenges.
+Ma's Reversing with 28 challenges.
TryThis0ne with 72 challenges.
Updated on 07/04/20 3:02:03 PM 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?

1 hacker solved 1 challenges today
Rumplestiltskin by Anone

View more stats

Member of The Internet Defense League

Care and feeding instructions