Carvana Operations Managers need a location-level view of market operations performance. Write a PostgreSQL query using Carvana market locations, completed orders, and recorded order errors.
Use 2025-02-15 as the reporting date, and analyze completed orders whose completed_at falls within the preceding 30 days, including both boundary dates.
Requirements
- Return every market location, including locations with no qualifying completed orders.
- Calculate completed order count and average cycle time in minutes.
- Calculate error rate as the percentage of completed orders with at least one associated error. Return
0.00 when a location has no completed orders.
- Sort results alphabetically by location name.
