query ผ่าตัด รายสัปดาห์

SELECT
    STR_TO_DATE(CONCAT(YEARWEEK(a.operation_date, 1), ' Monday'), '%x%v %W') AS week_start,
    DATE_ADD(STR_TO_DATE(CONCAT(YEARWEEK(a.operation_date, 1), ' Monday'), '%x%v %W'), INTERVAL 6 DAY) AS week_end,
    COUNT(DISTINCT a.an) AS visit
FROM
    operation_list a
INNER JOIN
    operation_detail c ON a.operation_id = c.operation_id
WHERE
    a.operation_date BETWEEN '2025-06-02' AND '2025-08-07'
GROUP BY
    week_start, week_end
ORDER BY
    week_start