select
    case strftime('%w', sales_date)
        when '0' then '日'
        when '1' then '月'
        when '2' then '火'
        when '3' then '水'
        when '4' then '木'
        when '5' then '金'
        when '6' then '土'
    end WEEK,
    count(sales_date) AVG_CNT,
    printf('%,d', sum(sales_amt)) || '円' AVG_AMT
from
    sales SL
where
    sales_type != 2
    and updated_no is null
    and sales_date between '2024-03-01' and '2024-03-28'
group by
    strftime('%w', sales_date)
order by
    strftime('%w', sales_date) asc