SELECT
  *
FROM
  (
    SELECT
      DATE(CONFIRMED_AT) AS REGIST_DATE,
      substr('日月火水木金土', STRFTIME("%w", DATE(CONFIRMED_AT)) + 1, 1) AS WK,
      COUNT(1) AS 'TOTAL'
    FROM
      USERS
    WHERE
      VALID_FLG == 1
    AND REGIST_DATE >= '2022-08-01'
    AND REGIST_DATE <= '2022-08-31'
    AND CONFIRMED_AT NOT NULL
    GROUP BY
      REGIST_DATE
  )