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 AS WEEK,
    ROUND(COUNT(SALES_NO) * 1.0 / COUNT(DISTINCT strftime('%Y-%m-%d', SALES_DATE))) AS AVG_CNT,
    CAST(ROUND(SUM(SALES_AMT) * 1.0 / COUNT(DISTINCT strftime('%Y-%m-%d', SALES_DATE))) AS INTEGER) || '円' AS AVG_AMT
FROM
    SALES
WHERE
    SALES_DATE BETWEEN '2024-03-01' AND '2024-03-28'
    AND SALES_TYPE != 2
    AND UPDATED_NO IS NULL
GROUP BY
    strftime('%w', SALES_DATE)
ORDER BY
    strftime('%w', SALES_DATE);