select u.Id, COUNT(a.Id) AS a_count from Users u inner jo...

0

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
  u.Id, COUNT(a.Id) AS a_count
  from Users u
  inner join Posts a on a.OwnerUserId = u.Id
  inner join Posts q on a.ParentId = q.Id
  where  
      a.PostTypeId = 2        -- Answers ..
  and q.tags LIKE '%<javascript>%'  -- to questions with the Javascript tag
  GROUP BY u.Id

Enter Parameters

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