WITH DATE_TBL AS (
    SELECT
        DATE('2022-08-01') AS CL_DATE
    UNION ALL
    SELECT
        DATE(CL_DATE, '+1 DAY')
    FROM
        DATE_TBL
    WHERE
        CL_DATE < '2022-08-31'
)
SELECT
    CL_DATE AS REGIST_DATE,
    CASE STRFTIME('%w', CL_DATE)
        WHEN '0' THEN '日'
        WHEN '1' THEN '月'
        WHEN '2' THEN '火'
        WHEN '3' THEN '水'
        WHEN '4' THEN '木'
        WHEN '5' THEN '金'
        WHEN '6' THEN '土'
    END AS WK,
    COUNT(USER_CODE) AS TOTAL
FROM
    DATE_TBL
LEFT JOIN
    USERS 
ON
    USERS.VALID_FLG = '1'
    AND CL_DATE = STRFTIME('%Y-%m-%d', USERS.CONFIRMED_AT)
GROUP BY
    CL_DATE
ORDER BY
    CL_DATE ASC
;