0

Please login or register to vote for this query.

(click on this box to dismiss)

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 ) z
group by wk
order by wk;

view current version

edited jan 17 19

created jan 17 19 Jack.Douglas