Attrition Rate
Easy
HR Analytics
Return the percentage of employees who have left the company (leave_date is not NULL), rounded to two decimals.
Table schema
Employees(id INT PRIMARY KEY, hire_date DATE, leave_date DATE NULL)Sample data
id | hire_date | leave_date
1 | 2020-01-01 | NULL
2 | 2021-03-01 | 2026-02-01
3 | 2022-05-01 | NULL
4 | 2023-07-01 | NULL
5 | 2024-01-01 | 2026-06-01
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.