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 '土' 
     ELSE NULL 
     END AS youbi
 ,round(count(SALES_NO)/4,0) as AVG_CNT
 ,round(sum(CAST(SALES_AMT AS REAL))/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 null
GROUP BY
 youbi