Compute each employee's tenure (years between HireDate and the fixed reference date 2026-06-12) and bucket them by experience.
| Column | Type |
|---|---|
| EmployeeId | INTEGER (PK) |
| LastName | TEXT NOT NULL |
| FirstName | TEXT NOT NULL |
| Title | TEXT |
| ReportsTo | INTEGER (FK → Employee) |
| BirthDate | TIMESTAMP |
| HireDate | TIMESTAMP |
| Country | TEXT |
FullName, Title, HireDate (date only), YearsAtCompany (integer, computed as of the fixed date 2026-06-12), BracketBracket: 'Veteran' if ≥ 18 years, 'Senior' if ≥ 15, 'Mid' if ≥ 10, else 'Junior'Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.