背景
我们知道clickhouse一般都是处理单表的数据，经常需要实现同环比等分析场景，这里提供两种方式：
首先计算公式：
同比、环比分析是一对常见的分析指标，其增长率公式如下：
----
同比增长率...= 0, -999, round((money - prev_month) / prev_month, 2)) AS month_over_month
FROM numbers(16)
┌──date_time...─┬─money─┬─prev_year─┬─prev_month─┬─year_over_year─┬─month_over_month─┐
│ 2019-01-01 │ 100 │...select timestamp,name,score,order_num,reverse_order_num,lag,lead from
(select timestamp, name, score,...by name order by timestamp desc) as reverse_order_num,
any(num) over (partition by name order by timestamp
