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 20 challenges this week
A curious escape by DrAMA
A different method by DrAMA
What's that say? III by BackMoon
Base 8^2 by BackMoon
A different method by BackMoon
Accessing routes by BackMoon
Classic Cipher Play II by BackMoon
Computer Talk by BackMoon
I came, I saw, I encrypted by BackMoon
Julius's Key by BackMoon
Hashed by BackMoon
New wave gibberish by BackMoon
Oink Oink by BackMoon
Pin-up Steganography by BackMoon
Pin-up Steganography II by BackMoon
The tools are out there by BackMoon
Selecting the right OS by BackMoon
Searching for clues by BackMoon
More classical review by BackMoon
Stego-what? by BackMoon

View more stats

Member of The Internet Defense League

Care and feeding instructions