如何在MYSQL表中求和每周小时数？

CREATE TABLE hours (
    id INT PRIMARY KEY AUTO_INCREMENT,
    employee_id INT,
    hours_worked DECIMAL(5,2),
    work_date DATE
);

SELECT WEEK(work_date) AS week_number, SUM(hours_worked) AS total_hours
FROM hours
GROUP BY week_number;

SELECT employee_id, WEEK(work_date) AS week_number, SUM(hours_worked) AS total_hours
FROM hours
GROUP BY employee_id, week_number;