Posts by Day of Week since Jan. 2020


Please login or register to vote for this query.

(click on this box to dismiss)

Number of posts by day of week, since Jan. 1, 2020

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

SELECT DATENAME(dw, CreationDate) AS dow,, COUNT(*) AS cnt

FROM Posts p
INNER JOIN posttypes pt ON

WHERE CreationDate >= '2020-01-01T00:00:00'

GROUP BY DATENAME(dw, CreationDate), name
ORDER BY name, cnt

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results