Routine~12min

The Closed Account Orders

Customer accounts marked as closed should no longer be able to place orders. But 13 orders came through on accounts where the closure date is before the order date — a stale session token persisted past account closure and allowed checkout to complete. One edge case: a same-day order placed before the closure timestamp is legitimate.

Tables you'll query

customersorders

What you'll learn

JOINsDate & Time Functions
Investigate this case →