Posts by Day of Week since Jan. 2020

1

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, pt.name, COUNT(*) AS cnt

FROM Posts p
INNER JOIN posttypes pt ON p.posttypeid=pt.id

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

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results