The Class of 2023

Kestrel Labs runs a single anniversary lunch each year for the whole intake that joined twelve months earlier, and HR is drawing up the invitation list for the 2023 cohort. The list is read out in the order people arrived, so the earliest joiner is thanked first and the newest last.

Start dates are stored as text like 2023-04-18, not as a year on its own, so the cohort has to be picked out of the full-date column.

employees — one row per person. department_id is the team they sit on, given as the matching id in departments; salary is annual pay in dollars; hire_date is the day they started, written year-month-day; manager_id is the id of the person they report to, and is NULL for anyone who reports to nobody.

The table already exists in the database — there is nothing to create or load.

Task: Write a query returning two columns, name and hire_date, one row per employee whose start date falls anywhere in the 2023 calendar year, earliest start first. Return hire_date exactly as stored, in year-month-day text. No two employees started on the same day, so the sequence is fully determined.

Example output — shape only, on invented people. The dates are returned as stored, in year-month-day text: