Tricky~21min
The Change Order Paid Without Approval
10 change orders were paid out while still pending or rejected — the payment run isn't actually checking approval status before releasing funds. 20 more change orders were paid under an approval_status of approved_verbal — a legitimate regional practice where a site manager approves by phone, not a violation.
Tables you'll query
change_orderspayments
What you'll learn
JOINs