大致的情况是这样的,有一张记录了每日交易量的一张表,如下所示:
with main as (
select '2020-08-01' as date_str,30 as amt
union all
select '2020-08-02' as date_str,500 as amt
union all
select '2020-08-04&
大致的情况是这样的,有一张记录了每日交易量的一张表,如下所示:
with main as (
select '2020-08-01' as date_str,30 as amt
union all
select '2020-08-02' as date_str,500 as amt
union all
select '2020-08-04&