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

SELECT substr('日月火水木金土', seq.no+1,1) WEEK
     , round(ifnull(cast(cnt as real) / 4,0),0) as AVG_CNT
     , printf('%,d円',round(ifnull(cast(amt as real) / 4,0),0)) as AVG_AMT
FROM seq
     LEFT JOIN t2 ON t2.wk = seq.no
order by seq.no