Back-To-School Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Simple CASE WHEN
7. Simple CASE WHEN – practice
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Summary

Instruction

All right. 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 (first_name, last_name), and a column fee_information which shows:

  • 'high' when the fee is 50.
  • 'low' in any other case.

Sort the rows by the name of the course in DESCending order.

Stuck? Here's a hint!

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