MySQL 按日累加求销量 按月累加求销量

Select
    a.id,
    a.product,
    a.sale_date,
    a.num ,
    (
        Select
            sum(num)
        FROM
            t_sale_stats b
        Where
            b.id <= a.id
        AND b.product = '产品名称'
        AND b.sale_date >= '2015-03-01'
        AND b.sale_date <= '2015-03-05'
    ) cum_num
FROM
    t_sale_stats a
Where
    a.sale_date >= '2015-03-01'
AND a.sale_date <= '2015-03-05'
AND a.product = '产品名称'
orDER BY
    a.id ASC;

Select
    a.id,
    a.product,
    a.trans_year,
   a.trans_month,
    a.num ,
    (
        Select
            sum(num)
        FROM
            t_order_month b
        Where
            b.id <= a.id
        AND b.product = 'productname'
      AND b.order_type='ordertype'
        AND b.trans_year >= '2018'
        AND b.trans_month >= '1'
        AND b.trans_year <= '2018'
        AND b.trans_month <= '5'
    ) cum_num
FROM
    t_order_month a
Where
a.product = 'productname'
        AND a.trans_year >= '2018'
        AND a.trans_month >= '1'
        AND a.trans_year <= '2018'
        AND a.trans_month <= '5'
      AND a.order_type='ordertype'
orDER BY
    a.id ASC;