0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for music historians, critics, and fans

select distinct year, count(tagid) as new_tags_used
from
(
select tagid, min(creationdate) as min_date, year(min(creationdate)) as year
from posts p
inner join posttags pt
on pt.postid = p.id
group by tagid
) a
group by year
order by year asc

fork query

edited nov 7

created nov 7 anonymous