Most Tags for a given Month and Year


Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select *,(100.0*anzahl/count(*)over())as ratings
from (
  select tagname,count(tagname) anzahl
  from (
    select id
    from posts 
    where month(creationdate)=##MonthNumber## and year(creationdate)=##YearNumber##) q1
  join posttags on
  join tags t on
  group by tagname) q2
order by anzahl desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results