Adjoined

You have three tables in a PostgreSQL database.
  • users
  • roles
  • user_roles
Produce a query that prints out each users name, password and role.
Sort ascending by user name.
The columns in your ResultSet MUST be named exactly, in this order:
  • Name
  • Password
  • Role


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

5 hackers solved 19 challenges this week
Pin-up Steganography by prefix
Play Fair! by suchCipher
What's that say? I by bakringle
What's that say? III by bakringle
What's that say? V by bakringle
I came, I saw, I encrypted by pronTooth
Logic Cubed by pronTooth
A different method by pronTooth
A different method by muffinx
Poking Around VI by muffinx
Poking Around III by muffinx
Mixing up the classics by muffinx
Searching for clues by muffinx
Cartoon Arithmetic by muffinx
Base 8^2 by prefix
I came, I saw, I encrypted by prefix
Logic Cubed by muffinx
Parse it fast by muffinx
Terminal Hacking by muffinx

View more stats

Member of The Internet Defense League

Care and feeding instructions