Company: IBM India-standard -Data Science
Difficulty: medium
A customer support team wants to analyze response times for resolving tickets to identify performance metrics and improve service quality. The goal is to generate a report calculating the average response time for successfully resolved customer support tickets. Resolved tickets have a value in the resolved_at field. The result should have the following columns: average_response_time . average_response_time - The average time between created_at and resolved_at , calculated in hours and set to two decimal places, including trailing zeros if necessary (e.g., 5.00). Schema support_tickets Name Type Constraint Description id INT PRIMARY KEY Unique identifier for each support ticket customer_id INT Reference to the customer who created the ticket created_at VARCHAR(19) Date and time when the ticket was created resolved_at VARCHAR(19) Date and time when the ticket was resolved Sample Data Tables support_tickets id customer_id created_at resolved_at 1 1 2023-12-21 05:42:00 2024-01-01 05:42:00