SELECT strftime('%Y-%m-%d', CREATED_AT) AS REGIST_DATE,
CASE strftime('%w', strftime('%Y-%m-%d', CREATED_AT))
WHEN '0' THEN '日'
WHEN '1' THEN '月'
WHEN '2' THEN '火'
WHEN '3' THEN '水'
WHEN '4' THEN '木'
WHEN '5' THEN '金'
WHEN '6' THEN '土'
END AS WK,
count(0) AS TOTAL 
FROM USERS
WHERE strftime('%Y-%m-%d', CREATED_AT) >= '2022-08-01' and strftime('%Y-%m-%d', CREATED_AT) <= '2022-08-31' 
GROUP BY strftime('%Y-%m-%d', CREATED_AT)