Employees Hired Before 2020-07-01

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

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

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

Difficulty: Beginner
SQL concept: Date Functions

This Pro challenge keeps its schema, dataset and solution behind subscription access. No protected answer content is included in public SEO data.