Introduction
Simple CASE WHEN
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Revision
25. Exercise 1

Instruction

Let's begin with something easy.

Exercise

For each course, show its name and the second column based on the column graduate_satisfaction:

  • if it's above 80, show 'satisfied',
  • if it's above 50, show 'moderately satisfied',
  • if it's 50 or less, show 'not satisfied'.

Console

Code editor

Result

TableConsole