Мок-собеседование на middle Data Engineer S1E6 | rzv_de | Sep 2024

[@mrbungle2553]

36:33 😭

[@user-xo5qg5vc4m]

Тогда python😂

[@ilyaghost1648]

SELECT
order_id,
AVG(TIMESTAMPDIFF(MINUTE,
MAX(CASE WHEN status_id = 10 THEN time_changed END),
MAX(CASE WHEN status_id = 5 THEN time_changed END)
)) AS time_diff
FROM OrderStatusChangelog
WHERE status_id IN (1, 10, 5)
GROUP BY order_id
HAVING MIN(YEAR(time_changed)) = 2022 AND status_id = 5