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(*) * 1.0 / 4, 0) AS AVG_CNT,
REPLACE(
PRINTF('%,d', ROUND(SUM(SALES_AMT) * 1.0 / 4, 0)),
',', ','
) || '円' AS AVG_AMT
FROM
SALES
WHERE
SALES_DATE BETWEEN '2024-03-01' AND '2024-03-28'
AND SALES_TYPE = 1
AND UPDATED_NO IS NULL
GROUP BY
STRFTIME('%w', SALES_DATE)
ORDER BY
STRFTIME('%w', SALES_DATE);