Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
-- Enter Query Title -- Enter Query Description GO SET NOCOUNT ON GO DECLARE @N int = 0 WHILE (@N < 24) BEGIN; SELECT @N as [Hour], AVG(Score) as [Score], AVG(ViewCount) as [Views] FROM Posts WHERE DATEPART(hh, CreationDate) = @N; SET @N = @N + 1 END; GO GO SET NOCOUNT ON GO