Compare effort with similar users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 1 pt.TagId
from Users u
join Posts p
  on  p.OwnerUserId = u.Id
  and p.PostTypeId = 2 --answer
join Posts q
  on q.Id = p.ParentId
join PostTags pt
  on pt.PostId = q.Id
where u.Id = 1607951 --##UserId##
group by pt.TagId
order by count(1) desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results