0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

--SELECT * FROM Tags
--WHERE TagName IN ('violin', 'piano', 'guitar', 'drums', 'trumpet', 'bass')

--SELECT COUNT(*) FROM Posts WHERE Tags LIKE '%<piano>%'

SELECT Tagname, YEAR(CreationDate) as CreationYear, COUNT(*) as count, SUM(ViewCount) as totalViews FROM PostTags pt, tags t, Posts p
  WHERE p.Id = pt.PostId AND pt.TagId = t.Id AND pt.TagId IN (SELECT Id FROM Tags 
  WHERE TagName IN ('violin', 'piano', 'guitar', 'drums', 'trumpet', 'bass'))
  GROUP BY TagName, YEAR(CreationDate)
  order by TagName, YEAR(CreationDate)


--SELECT Id FROM Tags WHERE TagName IN ('violin', 'piano', 'guitar', 'drums', 'trumpet', 'bass')

view current version

edited dec 3

created dec 3 jon.doe46464