SQL每日一题(20211028)即将每组CODE中缺少的日期，用上一个日期（RQ）所对应的数量（CNT）补齐

select t3.rq1 as rq,
       t3.code,
       t3.cnt
from (
         select t2.*,
                date_add(t2.rq, interval rn - 1 day) as rq1
         from (
                  select t1.*,
                         row_number() over (partition by rq,code order by rq) as rn
                  from (
                           select t.*
                           from (
                                    select *,
                                           lead(rq, 1, null) over (partition by code order by rq) a,
                                           ifnull(timestampdiff(day, rq,
                                                                lead(rq, 1, null) over (partition by code order by rq)),
                                                  1) as                                           rqc
                                    from t1028
                                ) t
                                    left join mysql.help_topic s on t.rqc >= s.help_topic_id + 1
                       ) t1
              ) t2
     ) t3
order by t3.code, t3.rq