SQL Server：按小时和星期几计算的平均计数

SQL Server：按小时和星期几计算的平均计数

sql
CREATE TABLE sales
(
    sale_date DATETIME,
    sale_count INT
)

sql
INSERT INTO sales (sale_date, sale_count)
VALUES ('2022-01-01 10:00:00', 5),
       ('2022-01-01 11:00:00', 10),
       ('2022-01-01 12:00:00', 8),
       ('2022-01-02 13:00:00', 15),
       ('2022-01-02 14:00:00', 20),
       ('2022-01-02 15:00:00', 12),
       ('2022-01-03 09:00:00', 7),
       ('2022-01-03 10:00:00', 9),
       ('2022-01-03 11:00:00', 11)

sql
SELECT DATEPART(HOUR, sale_date) AS sale_hour, AVG(sale_count) AS average_count
FROM sales
GROUP BY DATEPART(HOUR, sale_date)
ORDER BY DATEPART(HOUR, sale_date)

sql
SELECT DATEPART(WEEKDAY, sale_date) AS sale_weekday, AVG(sale_count) AS average_count
FROM sales
GROUP BY DATEPART(WEEKDAY, sale_date)
ORDER BY DATEPART(WEEKDAY, sale_date)