0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

SELECT TOP(50)
      TagName,
      round(sqrt(COUNT(*)),0) AS popularity
  FROM Tags
      INNER JOIN PostTags ON PostTags.TagId = Tags.id
  GROUP BY TagName
  ORDER BY 2 DESC

view current version

edited oct 15

created oct 15 anonymous