Challenge overview

What you will practice

List employees hired before 2018-01-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

Public schema and sample data

departments

id INTEGER	name TEXT	budget REAL	location TEXT
1	Engineering	1500000	New York
2	Marketing	800000	London
3	Sales	600000	Chicago

employees

id INTEGER	first_name TEXT	last_name TEXT	email TEXT	department_id INTEGER	salary REAL	hire_date TEXT	manager_id INTEGER
1	Alice	Johnson	alice@corp.com	1	95000	2019-03-15	NULL
2	Bob	Smith	bob@corp.com	1	85000	2020-06-01	1
3	Carol	Williams

Employees Hired Before 2018-01-01

What you will practice

Public schema and sample data

departments

employees