SQL Case study

Overview: Executed T-SQL analytical queries on an enterprise HR database (dbo.[HR Case Study]) to evaluate department compensation, analyze employee tenure and performance ratings, and conduct data quality audits across multi-region locations (Mumbai, Bengaluru, New Delhi).

Key SQL Operations & Analysis:

Departmental & Salary Filtering: Applied multi-condition logic (WHERE Department = 'Sales' AND Annual_Salary > 500000) to segment high-earning commercial personnel.

Data Ranking & Sorting: Ranked employee compensation in descending order (ORDER BY Annual_Salary DESC) to correlate earnings against performance ratings, age, distance to office, and company tenure.

Data Integrity Auditing: Performed null-value checks (WHERE Annual_Salary IS NULL) and flagged duplicate records using aggregation routines (COUNT(*) AS Repeated_Times) to maintain database integrity.