select
DATE(CONFIRMED_AT) as REGIST_DATE,
substr('日月火水木金土', strftime("%w", CONFIRMED_AT) +1, 1) as WK,
SUM(CAST(VALID_FLG as decimal)) as TOTAL
from
USERS
where
CONFIRMED_AT between '2022-08-01' and '2022-08-31'
and VALID_FLG='1'
group by
DATE(CONFIRMED_AT)
order by
REGIST_DATE