What tag is most common for first posts?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select count(*) N, TagName
from PostTags
     join Tags t on (t.Id = TagId)
where PostId in (
             select min(p.Id)
             from Users u
                  join Posts p on (u.Id = OwnerUserId)
                  join PostTypes type on (type.Id = PostTypeId)
             where type.Name in ('Question', 'Answer')
             group by OwnerUserId)
group by TagName
order by count(*) desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results