IBM Data Science, Recently Asked Online Assessments in 1 March, 2026 | SQL: Average Response Time

Question 1: Average Response Time Problem Statement: 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, ...