Routine~13min
The Coupon Used After It Expired
Finance is asking why SPRING20 kept getting applied after its expiry date. 7 orders used it between May 1st and May 2nd — a full day or more after it expired on April 30th at midnight. There's also a batch of WELCOME10 orders that look "late" too, but marketing extended that one's deadline in writing — check the extensions log before you flag it.
Tables you'll query
couponspromotion_extensionsorders
What you'll learn
JOINsDate & Time Functions