Routine~14min

The Parking Garage That Undercharged Overstays

Revenue audit found 6 vehicles that stayed 7-9 hours but were still billed the $15 flat rate instead of the hourly overstay rate — all entered between 2-3am, exactly when the exit kiosk's clock-sync job runs and its overstay check silently fails. Some cars stayed just 5-15 minutes past the 4-hour mark and were also billed flat rate — that's correct, the garage has a documented 20-minute grace period.

Tables you'll query

parking_sessions

What you'll learn

Date & Time FunctionsAggregations & GROUP BY
Investigate this case →