WITH SEQ AS (SELECT 0 AS no UNION ALL SELECT no + 1 AS no FROM SEQ WHERE no + 1 < 7)
   , t1 AS (SELECT s.SALES_DATE, CAST(STRFTIME('%w', s.SALES_DATE) AS int) w, COUNT(*) cnt, SUM(SALES_AMT) amt
            FROM SALES s
            WHERE SALES_TYPE <> 2
              AND UPDATED_NO IS NULL
              AND SALES_DATE BETWEEN '2024-03-01' AND '2024-03-28'
            GROUP BY s.SALES_DATE)

SELECT SUBSTR('日月火水木金土日', seq.no + 1, 1) WEEK
     , printf("%,d", ROUND(IFNULL(CAST(SUM(t1.cnt) AS real) / 4, 0), 0)) AVG_CNT
     , printf("%,d", ROUND(IFNULL(CAST(SUM(t1.amt) AS real) / 4, 0), 0)) || '円' AVG_AMT
FROM seq
     LEFT JOIN t1 ON seq.no = t1.w
GROUP BY seq.no
ORDER BY seq.no;