Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS
select (datepart(yy, p.creationdate) + datepart(wk, p.creationdate) / 52.0) as YR_WK , u.id as UID , count (*) as NumAnswers from users u inner join posts p on p.owneruserid = u.id and p.posttypeid = 2 and p.score > 0 group by (datepart(yy, p.creationdate) + datepart(wk, p.creationdate) / 52.0) , u.id