with serial as (
    select 0 as N
    union select 1 as N
    union select 2 as N
    union select 3 as N
    union select 4 as N
    union select 5 as N
    union select 6 as N
    union select 7 as N
    union select 8 as N
    union select 9 as N
    union select 10 as N
    union select 11 as N
    union select 12 as N
    union select 13 as N
    union select 14 as N
    union select 15 as N
    union select 16 as N
    union select 17 as N
    union select 18 as N
    union select 19 as N
    union select 20 as N
    union select 21 as N
    union select 22 as N
    union select 23 as N
    union select 24 as N
    union select 25 as N
    union select 26 as N
    union select 27 as N
    union select 28 as N
    union select 29 as N
    union select 30 as N
    union select 31 as N
    ), 

    user_list as (
    select strftime('%Y-%m-%d', 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 '不明'
            end as WK,
        USER_CODE
    from USERS
    where VALID_FLG='1'
    ),

s as (select REGIST_DATE,
       WK,
        COUNT(USER_CODE) as TOTAL
from user_list,serial

group by REGIST_DATE
order by 1)

select * from s
where REGIST_DATE BETWEEN '2022-08-01' and '2022-08-31'

;