SELECT
    SUBSTR('日月火水木金土', STRFTIME("%w", SALES_DATE)+1, 1) AS WEEK,
    ROUND(AVG(COUNT)) AS AVG_CNT,
    printf('%,d', ROUND(AVG(AMT))) || '円' AS AVG_AMT
FROM (
    SELECT
        SALES_DATE,
        COUNT(*) AS COUNT,
        SUM(SALES_AMT) AS AMT
    FROM SALES
    WHERE
        SALES_TYPE <> 2
        AND UPDATED_NO IS NULL
    GROUP BY
        SALES_DATE
) AS T
GROUP BY
    STRFTIME("%w", SALES_DATE)
ORDER BY
    STRFTIME("%w", SALES_DATE)