Routine~12min

The Weekend Rate on Weekdays

Service bookings on weekdays should be billed at the standard rate. But 23 bookings made Monday–Friday are showing rate_type='weekend' — the weekend premium rate. A bug in the rate-selection logic triggered when a booking was made within 48 hours of a weekend. Weekend bookings billed at weekend rate are fine — check the day of week.

Tables you'll query

bookings

What you'll learn

SELECT & FilteringDate & Time Functions
Investigate this case →