Introduction
3. Table application
Simple CASE WHEN
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Revision

Instruction

And finally the last table.

Exercise

Select all the information from the table application.

When a candidate applies for a certain degree course, a new application is created, containing the id of the candidate and of the course. The values from these two columns form the primary key. Pretty straightforward.

Then, we've got the amount of fee paid for the application (fee), the day when the payment was made (pay_date) and the status of application (status).

Console

Code editor

Result

TableConsole