This project solves 50 real-world SQL queries on an HR Analytics dataset using MySQL.
It covers employee attrition, salary trends, department performance, and job role analysis.
- Database: MySQL 8.0
- IDE: MySQL Workbench
- Dataset Format: Excel / CSV
| Dataset | Records | Type |
|---|---|---|
| HR_1 | 50,000+ | Excel/CSV |
| HR_2 | 50,000+ | Excel/CSV |
- ✅ Average Attrition Rate by Department
- ✅ Average Hourly Rate of Male Research Scientists
- ✅ Attrition Rate vs Monthly Income
- ✅ Average Working Years per Department
- ✅ Job Role vs Work-Life Balance
- ✅ Gender-based Salary Analysis
- ✅ Performance & Satisfaction Metrics
- Clone this repository
- Import HR_1 and HR_2 dataset into MySQL
- Run HR_Analytics_Queries.sql in MySQL Workbench
Sagar Shende
