TIMESTAMPDIFF(MINUTE, LAG(dt) OVER (PARTITION BY sender ORDER BY dt), dt) AS diff_minute, ROW_NUMBER() OVER (PARTITION BY sender ORDER BY dt) AS rownumber ...