WITH A AS(
	SELECT * FROM SALES
	WHERE
		SALES_TYPE <> 2
		AND UPDATED_NO IS NULL)
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(CNT)) AS AVG_CNT,
	ROUND(AVG(AMT)) AS AVG_MNT
FROM
(
SELECT
	COUNT(*) AS CNT,
	AVG(SALES_AMT) AS AMT,
	SALES_DATE
FROM
	A
GROUP BY SALES_DATE)
GROUP BY WEEK