group-by - Clickhouse group by 差异较小

Question

date_start             | date_end               | value
2020-12-05 11:00:00    | 2020-12-05 11:15:00    | 1
2020-12-05 11:15:00    | 2020-12-05 11:30:00    | 2
2020-12-05 11:30:00    | 2020-12-05 11:45:00    | 3
2020-12-05 13:00:00    | 2020-12-05 13:15:00    | 4

如果 date_start 的差小于 15 分钟，则对行进行分组并计算值的总和。

预期结果

date_start             | date_end               | sum
2020-12-05 11:00:00    | 2020-12-05 11:45:00    | 6
2020-12-05 13:00:00    | 2020-12-05 13:15:00    | 4

标签： group-bydifferenceclickhouse