Android questions per day


Please login or register to vote for this query.

(click on this box to dismiss)

Android questions per day in 2011

Stack Overflow

Q&A for programmers

-- Android questions per day
-- Android questions per day in 2011

  year(p.CreationDate) as [Year],
  month(p.CreationDate) as [Month],
  day(p.CreationDate) as [Day],
  count(*) as [QuestionsAskedToday]
from Posts p 
  inner join PostTags pt on = pt.postid
  inner join Tags t on = pt.tagid
  t.tagname = 'android' and
  p.CreationDate > '2011-01-01 00:00:00'
group by year(p.CreationDate), month(p.CreationDate),day(p.CreationDate)
with rollup
order by year(p.CreationDate), month(p.CreationDate) desc,day(p.CreationDate) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results