SELECT
DATE(CONFIRMED_AT) REGIST_DATE,
substr('日月火水木金土', strftime("%w", CONFIRMED_AT)+1, 1) WK,
COUNT(*) TOTAL

FROM
USERS

WHERE
CONFIRMED_AT IS NOT NULL
AND
strftime("%m", CONFIRMED_AT) = '08'
AND
VALID_FLG = '1'

GROUP BY
DATE(CONFIRMED_AT)