-- AMT確認用
select 
substr(SALES_DATE, 1, 7) as YEAR_MONTH,
SALES_AMT,
SALES_DATE
from SALES

where 
UPDATED_NO is null

order by YEAR_MONTH;


-- 月次集計

select 
-- *
substr(SALES_DATE, 1, 7) as YEAR_MONTH
,
sum(SALES_AMT)

from SALES

where 
UPDATED_NO is null

group by 
substr(SALES_DATE, 1, 7)
;



-- 売り上げ累計

select 
sum_month.YEAR_MONTH,
sum_month.sum_month_amt
, 
(
select sum(b.sum_month_amt) 
from 
    (
        select 
        substr(SALES_DATE, 1, 7) as YEAR_MONTH
        ,
        sum(SALES_AMT) as sum_month_amt
        
        from SALES
        
        where 
        UPDATED_NO is null
        
        group by 
        substr(SALES_DATE, 1, 7)
    ) as b
)


from
(
    select 
    substr(SALES_DATE, 1, 7) as YEAR_MONTH
    ,
    sum(SALES_AMT) as sum_month_amt
    
    from SALES
    
    where 
    UPDATED_NO is null
    
    group by 
    substr(SALES_DATE, 1, 7)
) as sum_month





-- 提出用