SQL: Detect Anomalies in Delivery Times

Problem Statement

Problem Description A logistics company wants to identify unusually long delivery times across different routes to optimize their operations and improve customer satisfaction. Your goal is to generate a report highlighting orders that took significantly longer than expected based on historical route performance. Write a query to find all orders where the delivery time is more than 1.5 times the average delivery time for that specific route. Schema The data is stored in a table named deliveries . Column Name Data Type Constraint Description id INT PRIMARY KEY Unique identifier for a delivery record. order_id INT Identifier for the order being delivered. route_id INT Identifier for the delivery route. delivery_start VARCHAR(19) The timestamp when the delivery started, stored as a string. delivery_end VARCHAR(19) The timestamp when the delivery ended, stored as a string. Required Output The result set should contain the following columns in this exact order: order_id : Unique identifier f