Routine~11min

The Self-Approver

Procurement policy is clear: no employee can approve their own purchase request above ₹5,000. But a bug in the approval workflow — triggered when a manager was on leave — let the system fall back to self-approval. Find all requests where the same person both raised and approved.

Tables you'll query

employeespurchase_requests

What you'll learn

SELECT & FilteringAggregations & GROUP BY
Investigate this case →