Tenure in Whole Years

Return each current employee (left_date IS NULL) and their tenure in whole years as of 2026-10-01 (completed 365.25-day years). Order by name.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(10), dept VARCHAR(10), hire_date DATE, left_date DATE)

Sample data

id | name | dept | hire_date | left_date
1 | Ann | IT | 2019-04-01 | NULL
2 | Bob | IT | 2021-08-15 | 2024-02-01
3 | Cy | HR | 2022-01-10 | NULL
4 | Dee | HR | 2020-06-01 | NULL
5 | Eli | IT | 2022-09-01 | 2025-03-01