Sort tags by popularity - Kunal

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

/*
This query finds out tag names used in all stack overflow posts.
And sorts these tags by popularity.
The result gives us a rough indication of what technologies
are popular throughout the world.
Check with Kunal if there are issues in the query.
*/

select
  t.tagName as 'Tag Name',  
  t.Count as 'Tag Popularity',
  e.body as 'Tag Description'
from tags t
left join Posts e
  on t.ExcerptPostId = e.Id
order by t.Count desc

Enter Parameters

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