Counts the number of posts on a given day
Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
-- How many questions have been posted on 2010-12-01?
-- Counts the number of posts on a given day
count(Id) as [Questions posted]
CreationDate > '2010-12-01 00:00'
CreationDate < '2010-12-01 23:59:59'
PostTypeId = 1