SELECT
    date(CONFIRMED_AT, 'localtime') AS REGIST_DATE
    ,CASE WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '0' THEN '日'
          WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '1' THEN '月'
          WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '2' THEN '火'
          WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '3' THEN '水'
          WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '4' THEN '木'
          WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '5' THEN '金'
          WHEN strftime("%w", CONFIRMED_AT, 'localtime') = '6' THEN '土'
          END AS WK
    ,COUNT(*) AS TOTAL
FROM USERS
WHERE VALID_FLG = '1' AND CONFIRMED_AT IS NOT NULL
    AND REGIST_DATE >= '2022-08-01' AND REGIST_DATE <= '2022-08-31'
GROUP BY REGIST_DATE, WK
ORDER BY REGIST_DATE