Q&A for people looking to bypass life's everyday problems with simple tricks
select datepart(dw, creationdate) as hourPart, count(datepart(dw, creationdate)) as number from posts group by datepart(dw, creationdate) order by hourPart