如何根据每天的每小时数据对SQL Server中从上午8点到下午8点的12小时范围内的每小时间隔数据进行平均？

SELECT 
    DATEADD(HOUR, DATEPART(HOUR, yourTimestampColumn), CONVERT(DATE, yourTimestampColumn)) AS HourlyInterval,
    AVG(yourDataColumn) AS AverageData
FROM 
    yourTable
WHERE
    yourTimestampColumn >= DATEADD(HOUR, 8, CONVERT(DATE, yourTimestampColumn))
    AND yourTimestampColumn < DATEADD(HOUR, 20, CONVERT(DATE, yourTimestampColumn))
GROUP BY 
    DATEADD(HOUR, DATEPART(HOUR, yourTimestampColumn), CONVERT(DATE, yourTimestampColumn))

CREATE PROCEDURE GetHourlyAverages
    @startDate DATE,
    @endDate DATE
AS
BEGIN
    SELECT 
        DATEADD(HOUR, DATEPART(HOUR, yourTimestampColumn), CONVERT(DATE, yourTimestampColumn)) AS HourlyInterval,
        AVG(yourDataColumn) AS AverageData
    FROM 
        yourTable
    WHERE
        yourTimestampColumn >= DATEADD(HOUR, 8, CONVERT(DATE, yourTimestampColumn))
        AND yourTimestampColumn < DATEADD(HOUR, 20, CONVERT(DATE, yourTimestampColumn))
        AND yourTimestampColumn >= @startDate
        AND yourTimestampColumn < DATEADD(DAY, 1, @endDate)
    GROUP BY 
        DATEADD(HOUR, DATEPART(HOUR, yourTimestampColumn), CONVERT(DATE, yourTimestampColumn))
END