SQL 统计日环比、周同比

date	gmv
2019-01-01	115.7
2019-01-02	180.1
2019-01-03	296.8
2019-01-04	706.0
2019-01-05	703.5
2019-01-06	527.3
2019-01-07	462.9
2019-01-08	270.1
2019-01-09	23.3
2019-01-10	346.4
2019-01-11	468.4
2019-01-12	728.1
2019-01-13	841.4

select date,gmv,(gmv-gmv_1)/gmv_1,(gmv-gmv_7)/gmv_7
from
(select date,gmv,
lead(gmv,1) over(order by date desc) as gmv_1,
lead(gmv,7) over(order by date desc) as gmv_7 from tablename) a