0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Number of unique users that have used a tag at least once
-- Enter Query Description

select top 100
  t.TagName            as [Tag],
  count(distinct u.Id) as [Users]
from
   users    u  inner join
   posts    p  on u.Id = p.OwnerUserId
               inner join
   posttags pt on p.Id = pt.PostId
               inner join
   tags     t  on pt.TagId = t.Id
where p.PostTypeId = 1
group by t.Id, t.TagName
order by count(distinct u.Id) desc;

fork query

created aug 19 10 MPelletier