SQL for Recent Hires

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

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

Output

1. One row per qualifying employee, with columns employee_id, full_name, job_title, hire_date, office_name, and city.
2. Include only employees hired from 2026-02-28 through 2026-08-29, inclusive, with a matching office record. Rows with a NULL hire_date are excluded.
3. Sort by hire_date descending, then employee_id ascending.