根据日期计算月累计数量

image.png

根据issuedate 排序，
计算issuecount-endcount的值，得到sumdata字段

image.png

使用子查询
select
    issuecount,
    endCount,
    endDate,
    issueDate,
    sumData,
    (
    select
        SUM(sumData)
        from lastData as i
    where
        i.issueDate <= o.issueDate) as total
from
    lastData as o

image.png