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, count(*)
from( select concat(datepart(year,creationdate)
                   ,'W'
                   ,format(datepart(week,creationdate),'00')) wk
      from posts
      where posttypeid=1 and creationdate>'2019-01-01' ) z
group by wk
order by wk;

Enter Parameters

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