0

Please login or register to vote for this query.

(click on this box to dismiss)

Edit start/end dates for current month.

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

-- 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%'
group by convert(varchar(8), CreationDate, 126)
order by convert(varchar(8), CreationDate, 126) desc;

view current version

edited apr 20 11

created apr 20 11 Roman Nurik