Introduction
Simple CASE WHEN
7. Simple CASE WHEN – practice
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Revision

Instruction

Alright. Let's do a more demanding exercise with JOINs!

Exercise

Show the following columns: name of the course, first and last name of the candidate, column fee_information which shows:

  • 'high' when the fee is 50
  • or 'low' in any other case.
Sort the rows by the name of the course in the DESCending order.

Stuck? Here's a hint!

Here, you'll need to join three tables and sort the rows using ORDER BY.

Console

Code editor

Result

TableConsole