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?

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

New Challenges
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
What's that say? III
Base 8^2
I came, I saw, I encrypted
What goes there?

3 hackers solved 41 challenges this week
Inserted by xaav
Julius's Key by xaav
Logic Cubed by xaav
Poking Around IV by xaav
Templar Decoder Ring by xaav
A different method by mglarragan
Return to sender by xaav
Crackerjack Encryption by xaav
Selecting the right OS by xaav
Classic Cipher Play III by mglarragan
Javascript Entertainment by xaav
Malformed by xaav
Oink Oink by xaav
More classical review by xaav
On the fence by xaav
Play Fair! by xaav
New wave gibberish by xaav
Poking Around V by xaav
Poking Around VI by xaav
Julius's Key by mglarragan
Mixing up the classics by mglarragan
More classical review by mglarragan
On the fence by mglarragan
Play Fair! by mglarragan
Real Men of Genius I by mglarragan
Real Men of Genius II by mglarragan
Templar Decoder Ring by mglarragan
Calculating the Combination by mglarragan
What goes there? by mglarragan
The tools are out there by xaav
What's that say? I by xaav
What's that say? II by xaav
What's that say? IV by xaav
What goes there? by xaav
Hop Skip and Jump by xaav
Real Men of Genius I by xaav
Oink Oink by Cluentia
Accessing routes by Cluentia
World War I by xaav
Where ya coming from? by xaav
Mixing up the classics by xaav

View more stats

Member of The Internet Defense League

Care and feeding instructions