with
    dating as (
        select
            '2022-08-01' dating
        union all
        select
            date (dating, '+1 day') d
        from
            dating
        where
            d < '2022-09-01'
    )
select
    dating.dating REGIST_DATE,
    case strftime ('%w', dating.dating)
        when '0' then '日'
        when '1' then '月'
        when '2' then '火'
        when '3' then '水'
        when '4' then '木'
        when '5' then '金'
        when '6' then '土'
    end WK,
    count(
        case USERS.VALID_FLG
            when '1' then 1
        end
    ) TOTAL
from
    dating
    left join USERS on date (USERS.CONFIRMED_AT) = dating.dating
group by
    dating.dating;