Questions Per Day History

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biblical Hermeneutics

Q&A for professors, theologians, and those interested in exegetical analysis of biblical texts

select wk, round(count(*)/7,1) qpd
from( select wk, max_wk = max(wk) over ()
      from( select wk = concat(datepart(year,creationdate)
                              ,'W'
                              ,format(datepart(week,creationdate),'00'))
            from posts
            where posttypeid=1 ) z ) z
where wk<>max_wk
group by wk
order by wk desc;

Enter Parameters

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