SELECT DATE(CONFIRMED_AT) 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 '土'
            ELSE 'undefined'
        END AS WK
      ,COUNT(*)
  FROM USERS
 WHERE REGIST_DATE >= '2022-08-01'
   AND REGIST_DATE < '2022-09-01'
 GROUP BY REGIST_DATE
 ORDER BY REGIST_DATE
;