Routine~10min
The Underpaid Staff
HR flagged a compliance concern: some part-time staff may be earning below the statutory minimum hourly rate of ₹176. The legacy onboarding portal didn't enforce a rate floor. Find which employees are underpaid — and double-check the one who looks borderline.
Tables you'll query
employees
What you'll learn
SELECT & FilteringAggregations & GROUP BY