Routine~12min
The Gym Membership Charged After Cancellation
Billing support is fielding angry calls — 5 members who cancelled were still charged $49 on the next cycle. The billing job reads member status at the start of the day, so cancellations processed same-day slip through by one extra run. Some members do show a charge on their exact cancellation day, but those charges happened hours before they cancelled — leave those alone.
Tables you'll query
memberscharges
What you'll learn
JOINsDate & Time Functions