Top Mapbox Stack Overflow Answerers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT au.DisplayName as "Display name", 
       au.WebsiteUrl + 'hello' as "Website URL",
       COUNT(*) as "Number of accepted answers"
FROM PostTags as pt 
  JOIN Tags as t ON pt.TagId = t.Id
  JOIN Posts as p ON pt.PostId = p.Id
  JOIN Posts as a ON p.AcceptedAnswerId = a.id
  JOIN Users au ON a.OwnerUserId = au.Id
WHERE (t.TagName like '%mapbox%') 
  and (au.CreationDate like '%2019%') or (au.CreationDate like '%2020%')
GROUP BY au.DisplayName, au.WebsiteURL
HAVING COUNT(*) > 20
ORDER BY COUNT(*) DESC

Enter Parameters

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