0

Please login or register to vote for this query.

(click on this box to dismiss)

Grouped by Month

Q&A for pro webmasters

-- Number of Android questions and answers on Stack Overflow
-- Grouped by Month

  select convert(varchar(8), CreationDate, 126) as Date, count(id) as Questions, sum(AnswerCount) as Answers
    from Posts
   where Tags like '%android%' and ((DATEPART(dw, CreationDate) + @@DATEFIRST) % 7) NOT IN (0, 1)
group by convert(varchar(8), CreationDate, 126)
order by convert(varchar(8), CreationDate, 126) desc;

fork query

created jul 14 11 julio.gorge