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(*)/7 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;

fork query

edited jan 17 19

created jan 17 19 Jack.Douglas