Company: Zomato_product_Analyst
Difficulty: medium
High Delivery Time Analysis Problem Description You are provided with a dataset containing delivery records. Each record consists of a delivery date, a delivery start time, and a delivery end time. Your task is to perform the following calculations and filter the data: 1. Calculate the actual delivery time for each row, which is the difference between the delivery end time and the delivery start time. 2. Calculate the average delivery time across all rows in the dataset. 3. Find and print/return the rows where the actual delivery time is strictly greater than 1.5 * average delivery time. Examples Example 1: Input: | id | delivery_date | start_time | end_time | |----|---------------|------------|----------| | 1 | 2023-09-01 | 08:00 | 10:00 | | 2 | 2023-09-01 | 09:00 | 09:30 | | 3 | 2023-09-02 | 14:00 | 15:10 | Output: | id | delivery_date | start_time | end_time | |----|---------------|------------|----------| | 1 | 2023-09-01 | 08:00 | 10:00 | Explanation: * Row 1 Duration: 10:00 - 08: