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).