MS SQL，如何按时段(每个工作日)内的时段(小时)获取汇总参数

SELECT DATEPART(HOUR, timestamp) AS hour, SUM(parameter_value) AS total_value
FROM parameter_data
GROUP BY DATEPART(HOUR, timestamp)

SELECT DATEPART(WEEKDAY, timestamp) AS weekday, DATEPART(HOUR, timestamp) AS hour, SUM(parameter_value) AS total_value
FROM parameter_data
WHERE DATEPART(WEEKDAY, timestamp) BETWEEN 2 AND 6 -- 2表示星期一，6表示星期五
GROUP BY DATEPART(WEEKDAY, timestamp), DATEPART(HOUR, timestamp)

SELECT weekday, hour, SUM(total_value) AS total_value
FROM (
    SELECT DATEPART(WEEKDAY, timestamp) AS weekday, DATEPART(HOUR, timestamp) AS hour, SUM(parameter_value) AS total_value
    FROM parameter_data
    WHERE DATEPART(WEEKDAY, timestamp) BETWEEN 2 AND 6 -- 2表示星期一，6表示星期五
    GROUP BY DATEPART(WEEKDAY, timestamp), DATEPART(HOUR, timestamp)
) AS subquery
GROUP BY weekday, hour