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

## Instruction

Ok. Now, let's find out who the candidates are!

## Exercise

Select all the information from the table candidate.

Each person who is willing to enroll in a course will have:

• a unique identifier (id),
• first and last name (first_name, last_name),
• two scores (score_math, score_language) which are the results of two preliminary tests these students need to take: in mathematics and in language (the maximum score for each part is 100),
• finally, there is the preferred method of contact (preferred_contact).