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