WITH daygrp AS(
    SELECT
        SALES_DATE,
        SUM(SALES_AMT) sumamt,
        COUNT(SALES_AMT) cnt
    FROM
        SALES
    WHERE
        SALES_DATE BETWEEN '2024-03-01'
        AND '2024-03-28'
        AND SALES_TYPE <> 2
        AND UPDATED_NO IS NULL
    GROUP BY
        SALES_DATE
)
SELECT
    CASE
        WHEN strftime('%w', SALES_DATE) = '0' THEN '日'
        WHEN strftime('%w', SALES_DATE) = '1' THEN '月'
        WHEN strftime('%w', SALES_DATE) = '2' THEN '火'
        WHEN strftime('%w', SALES_DATE) = '3' THEN '水'
        WHEN strftime('%w', SALES_DATE) = '4' THEN '木'
        WHEN strftime('%w', SALES_DATE) = '5' THEN '金'
        WHEN strftime('%w', SALES_DATE) = '6' THEN '土'
    END AS 'WEEK',
    CASE
        WHEN round(AVG(cnt)) = 0 THEN 0
        ELSE round(AVG(cnt), 0)
    END AS 'AVG_CNT',
    CASE
        WHEN round(AVG(sumamt)) = 0 THEN 0 || '円'
        ELSE round(AVG(sumamt), 0) || '円'
    END AS 'AVG_AMT'
FROM
    daygrp
GROUP BY
    strftime('%w', SALES_DATE)