Simple CASE WHEN
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Instruction
Okay, and the last one?
Exercise
For each degree course, show its name, the place_limit, the number of people who applied for that degree course (as candidates_no) and yet another column popularity: if more people applied than place_limit, show 'overcrowded'. Otherwise, show 'within limit'.
Stuck? Here's a hint!
Consider people who didn't get accepted for the first time and applied again – in other words: use DISTINCT when counting candidates' IDs.
