Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Table application
Simple CASE WHEN
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Summary

Instruction

And finally the last table.

Exercise

Select all the information from the table application. Remember, if a table has many rows (and that's the case here), our platform doesn't display all rows due to readability).

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 the fee paid for the application (fee), the day when the payment was made (pay_date) and the status of application (status).