Compare effort with similar users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

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 main site
loading Hold tight while we fetch your results