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, 2) 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 <> 2

AND UPDATED_NO IS NOT NULL

GROUP BY

STRFTIME('%w', SALES_DATE)

ORDER BY

STRFTIME('%w', SALES_DATE);