# 窗口函数 with temp as ( select tag, dt, sum(sum_like) over(PARTITION BY tag ORDER BY dt RANGE BETWEEN INTERVAL 6 DAY PRECEDING AND CURRENT ROW) as sum_like_cnt_7d, max(sum_re) over(PARTITION BY tag ORDER BY dt RANGE BETWEEN INTERVAL 6 DAY PRECEDING AND CURRENT ROW) as max_re...