Tenure Buckets

Treat 2026-10-06 as today. Label each employee's tenure as '<1 year' (less than 1 year), '1-3 years' (at least 1 and less than 3) or '3+ years'. Return name and bucket ordered by name.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(50), hire_date DATE)

Sample data

id | name | hire_date
1 | Amy | 2026-03-01
2 | Ben | 2024-01-01
3 | Cara | 2020-01-01