SELECT 
SUBSTRING(CONFIRMED_AT,0,11) AS REGIST_DATE
, case strftime('%w', CONFIRMED_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(USER_CODE) AS TOTAL

FROM USERS
WHERE VALID_FLG = 1
AND SUBSTRING(CONFIRMED_AT,0,11) LIKE '2022-08-%'

GROUP BY SUBSTRING(CONFIRMED_AT,0,11)
ORDER BY 1