SELECT 
SUBSTRING(CONFIRMED_AT,0,11) AS REGIST_DATE
,CASE WHEN strftime('%w', CONFIRMED_AT) = 0 THEN '日'
 WHEN　strftime('%w', CONFIRMED_AT) = 1  THEN '月'
  WHEN　strftime('%w', CONFIRMED_AT) = 2  THEN '火'
   WHEN　strftime('%w', CONFIRMED_AT) = 3  THEN '水'
    WHEN　strftime('%w', CONFIRMED_AT) = 4  THEN '木'
     WHEN　strftime('%w', CONFIRMED_AT) = 5  THEN '金'
      WHEN　strftime('%w', CONFIRMED_AT) = 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