Q&A for administrators, end users, developers and designers for Craft CMS
select datepart(dw, creationdate) as hourPart, count(datepart(dw, creationdate)) as number from posts group by datepart(dw, creationdate) order by hourPart