Q&A for Ubuntu users and developers
-- At what hour should I add ask questions to get more answers?
-- At what hour do I ask most questions?
DECLARE @UserId int = ##UserId##
DATEPART(hour, CreationDate) as hour,
GETUTCDATE() as utc_hour,
COUNT(*) as number
WHERE OwnerUserId = @UserId
GROUP BY DATEPART(hour, CreationDate)