Questions per Day (last 6 month)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

Вопросы и ответы для программистов

DECLARE @CutoffDate datetime
SET @CutoffDate = dateadd(month, -6, GETUTCDATE()) 

select 
DATEFROMPARTS(year(CreationDate), month(CreationDate), day(CreationDate)) as [Date]
, count(*)
from Posts where ParentId is null and CreationDate > @CutoffDate
group by year(CreationDate), month(CreationDate), day(CreationDate)
order by year(CreationDate), month(CreationDate), day(CreationDate) asc

Enter Parameters

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