Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language
-- 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_date,
GETDATE() as date,
COUNT(*) as number
WHERE OwnerUserId = @UserId
GROUP BY DATEPART(hour, CreationDate)