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
mglarragan : Pin-up Steganography II
ross46 : What's that say? I
darkvenom : What's that say? I
9iujhbhgfrrrrfghjk : A curious escape
Cluentia : Templar Decoder Ring
xaav : A different method

Partner Sites
Halls of Valhalla
Additional Challenge Sites
HackThisSite with 102 challenges.
Solve Me with 21 challenges.
Challengeland with 70 challenges.
µContest with 56 challenges.
Hacker Gateway with 215 challenges.
Updated on 05/23/18 4:14:41 AM UTC
It's only a game!

Research harder

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?

Member of The Internet Defense League

Care and feeding instructions