0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

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

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

SELECT pt.TagId, COUNT(*) FROM PostTags pt, Posts p, tags t
WHERE p.Id = pt.PostId AND pt.TagId IN (SELECT Id FROM Tags WHERE TagName IN ('violin', 'piano', 'guitar', 'drums', 'trumpet', 'bass'))
GROUP BY pt.TagId
--SELECT Id FROM Tags WHERE TagName IN ('violin', 'piano', 'guitar', 'drums', 'trumpet', 'bass')

view current version

edited dec 3

created dec 3 jon.doe46464