Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language
-- At what hour do I ask most posts, both questions and answers?
-- UTC (GMT) time zone. The week starts with Sunday.
-- HourOrDOW (1 - hours, 2 - day of week)
-- DEFINE @var = DATEPART("weekday", CreationDate), DATENAME("hour", CreationDate);
WITH grouped AS
SELECT *, (CAST(DATEPART("weekday", CreationDate) AS float) + CAST(DATEPART("hour", CreationDate) AS float) / 24) AS cd
cd AS [Day of week + time],
COUNT(*) AS [Number of posts]
GROUP BY cd
ORDER BY cd