Q&A for professional and enthusiast programmers
select * from (select t.tagname,count(t.tagname) as total from posts p inner join posttags pt on (p.id = pt.PostId) inner join tags t on (t.id = pt.tagId) where p.creationDate > '2013-09-05'And p.creationDate < '2013-09-07' and p.postTypeId = 1 group by t.tagname) as r order by total desc