Android questions per day
Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language
-- Android questions per day -- Android questions per day --count(*) 114099 select year(p.CreationDate), month(p.CreationDate),day(p.CreationDate), count(*) from Posts p inner join PostTags pt on p.id = pt.postid inner join Tags t on t.id = pt.tagid where t.tagname = 'android' and p.CreationDate > '2011-01-01 00:00:00' group by year(p.CreationDate), month(p.CreationDate),day(p.CreationDate) order by year(p.CreationDate), month(p.CreationDate) desc,day(p.CreationDate) desc