Employees Hired Before 2021-01-01

List employees hired before 2021-01-01, newest qualifying hire first. Return columns: first_name, last_name, hire_date. Order results by: hire_date DESC, id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

List employees hired before 2021-01-01, newest qualifying hire first. Return columns: first_name, last_name, hire_date. Order results by: hire_date DESC, id.

Difficulty: Beginner
SQL concept: Date Functions