SQL for Recent Hires

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL for Recent Hires. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Jones Lang LaSalle wants a current hiring report for employees who joined within the previous six months. Write a PostgreSQL query using each employee's hire_date, joining the employee record to its JLL office.

Assume the query runs on 2026-08-29. The six-month boundary is inclusive, so employees hired on 2026-02-28 should be included.

Requirements

Return the employee ID, name, job title, hire date, office name, and city.
Include only employees whose hire date is between the six-month boundary and the run date, inclusive.
Exclude employees without a matching office record.
Sort by most recent hire date first, then employee ID ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
full_name	VARCHAR(100)	Employee's full name
job_title	VARCHAR(100)	Employee's job title
hire_date	DATE	Date the employee joined JLL
office_id	INT	References jll_offices.office_id

jll_offices

Column	Type	Description
office_idPK	INT	Unique JLL office identifier
office_name	VARCHAR(100)	JLL office name
city	VARCHAR(80)	City containing the office

Tablesemployeesjll_offices

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results