WITH TGT AS (
  SELECT
    strftime("%w", SALES_DATE) AS WEEK,
    ROUND(COUNT(SALES_NO) / 4.0) AS AVG_CNT,
    ROUND(AVG(SALES_AMT)) AS AVG_AMT
  FROM
    SALES
  WHERE
    TRUE
    AND SALES_DATE BETWEEN '2024-03-01'
    AND '2024-03-28'
    AND SALES_TYPE <> 2
    AND UPDATED_NO IS NULL
  GROUP BY
    WEEK
  ORDER BY
    WEEK
)
SELECT
  CASE
    WEEK
    WHEN '0' THEN '日'
    WHEN '1' THEN '月'
    WHEN '2' THEN '火'
    WHEN '3' THEN '水'
    WHEN '4' THEN '木'
    WHEN '5' THEN '金'
    WHEN '6' THEN '土'
  END AS WEEK,
  AVG_CNT,
  REPLACE(AVG_AMT, '.0', '') || '円' AS AVG_AMT
FROM
  TGT