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

## 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.