Pass, Fail or Skipped?

You have three tables in a PostGRE SQL database.
  • users
  • courses
  • user_scores
Recently our organization held mandatory sexual harassment training courses. We need to produce a report for senior staff detailing staff participation and results in this course only. Produce a recordset that will be used to generate the report delivered to management. This recordset must containing the following three columns.
  • Name
    Contains the persons name. Sort ascending.

  • Course
    Contains the name of the course.

  • Score
    Contains the person's score. If the person scored underneath the minimum score for this course, this field should be populated with the text "Failed". If this person has not yet taken the course, this field should be populated with the text "Not yet taken".


Columns must be named exactly.

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

1 hacker solved 21 challenges in 48 hours
Reversing the application II by alanzee
Reversing the application III by alanzee
Digging Deeper by alanzee
Logjam Disarray by alanzee
Poking Around II by alanzee
Poking Around I by alanzee
Poking Around IV by alanzee
Poking Around V by alanzee
Poking Around VI by alanzee
Mixing up the classics by alanzee
Classic Cipher Play II by alanzee
Craptcha III by alanzee
Wheel of Fortune by alanzee
Pin-up Steganography II by alanzee
Message for you sir! by alanzee
More classical review by alanzee
Thin Air by alanzee
Unusual Translation by alanzee
JSON and the Argonauts I by alanzee
Poking Around III by alanzee
Acknowledging our forebears by alanzee

View more stats

Member of The Internet Defense League

Care and feeding instructions