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(AVG(
       CASE
           WHEN SALES_TYPE = 1 AND UPDATED_NO IS NULL THEN 1
           ELSE 0
       END
   ), 0) AS AVG_CNT,
   REPLACE(PRINTF('%d', ROUND(AVG(
       CASE
           WHEN SALES_TYPE = 1 AND UPDATED_NO IS NULL THEN SALES_AMT
           ELSE 0
       END
   ), 0)), ' ', ',') || '円' AS AVG_AMT
FROM
   SALES
WHERE
   SALES_DATE BETWEEN '2024-03-01' AND '2024-03-28'
   AND SALES_TYPE <> 2
GROUP BY
   WEEK
ORDER BY
   CASE WEEK
       WHEN '日' THEN 0
       WHEN '月' THEN 1
       WHEN '火' THEN 2
       WHEN '水' THEN 3
       WHEN '木' THEN 4
       WHEN '金' THEN 5
       WHEN '土' THEN 6
   END;