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
,ifnull(CASE WHEN VALID_FLG = 1 THEN SUM(VALID_FLG)
 WHEN 0 then 0 END,0) AS TOTAL

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

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