Questions Per Day History


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(*)/7 qpd
from( select wk, max_wk = max(wk) over ()
      from( select wk = concat(datepart(year,creationdate)
            from posts
            where posttypeid=1 ) z ) z
where wk<>max_wk
group by wk
order by wk desc;

Enter Parameters

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