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
Investigate this case →