find number of questions for a list of tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

given a list of tags find out how many question each of the tags has

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

-- find number of questions for a list of tags
-- given a list of tags find out how many question each of the tags has

select Tags.Tagname, count(Posts.Id) as questions, sum(ViewCount) as views from Posts left join
  PostTags on PostS.Id = PostTags.PostId left Join
  Tags on PostTags.TagId = Tags.Id
where
  Tags.TagName in (

-- enter tags here

'.net',
'Appfabric',
'Appfabric-beta-2',
'Azure',
'Azure-storage-blobs',
'Azure-storage-tables',
'Azure-tables',
'Azure-worker-roles',
'Cloud',
'Cloud-computing',
'Cloud-hosting',
'Corporate',
'Database',
'Data-storage',
'Deployment',
'Enterprise',
'Enterprise-development',
'Microsoft',
'Relational-database',
'Sdk',
'Server',
'Software-development',
'Sql',
'Sql-azure',
'Sql-server',
'Virtual-machine',
'VM',
'VMWare',
'Windows-azure',
'Windows-azure-storage')
group by Tags.TagName

Enter Parameters

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