Introduction
2. Table candidate
Simple CASE WHEN
Searched CASE WHEN
CASE WHEN with aggregates
CASE WHEN with GROUP BY
Revision

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 maximal score for each part is 100),
  • finally, there is the preferred form of contact (preferred_contact).

Console

Code editor

Result

TableConsole