Questions Asked by Day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the number of questions asked each day

Mathematics

Q&A for people studying math at any level and professionals in related fields

-- Questions Asked by Day
-- Shows the number of questions asked each day

select
datepart(year, Posts.CreationDate) Year,
datepart(month, Posts.CreationDate) Month,
datepart(day, Posts.CreationDate) Date,
count(Posts.Id) Questions
from Posts
where PostTypeid = 1 -- 1 = Question
group by datepart(year, Posts.CreationDate), datepart(month, Posts.CreationDate), datepart(day, Posts.CreationDate)
order by datepart(year, Posts.CreationDate), datepart(month, Posts.CreationDate), datepart(day, Posts.CreationDate);

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results