Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Attrition Rate

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.