Introduction
Simple CASE WHEN
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Revision
27. Exercise 3

Instruction

Fine! How about the third one?

Exercise

Show each degree course name and the second column called popularity. If at least 5 candidates applied, show 'high', otherwise show 'low'.

Console

Code editor

Result

TableConsole