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!