Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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