SELECT
DATE_FORMAT(CONFIRMED_AT,'%Y-%m-%d') AS REGIST_DATE,
DATENAME(WEEKDAY,REGIST_DATE) AS WK,
COUNT(REGIST_DATE) AS TOTAL

FROM USERS

WHERE 
VALID_FLG='1' AND
LEFT(CONFIRMED_AT,7) = '2022-08'

GROUP BY 
REGIST_DATE

ORDER BY REGIST_DATE ASC;