SELECT
DATE(CONFIRMED_AT) AS REGIST_DATE,
CASE strftime("%w", DATE(CONFIRMED_AT))
    WHEN "0" THEN "日"
    WHEN "1" THEN "月"
    WHEN "2" THEN "火"
    WHEN "3" THEN "水"
    WHEN "4" THEN "木"
    WHEN "5" THEN "金"
    WHEN "6" THEN "土"    
END as WK,
SUM(USER_CODE) AS TOTAL
FROM USERS
WHERE VALID_FLG = "1"
AND DATE(CONFIRMED_AT) BETWEEN "2022-08-01" AND "2022-08-31"
GROUP BY DATE(CONFIRMED_AT)
ORDER BY DATE(CONFIRMED_AT) ASC