0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for music historians, critics, and fans

SELECT T.TagName, MIN(P.CreationDate) AS FirstUseDt
FROM Tags T
JOIN PostTags PT
On T.Id = PT.TagId
JOIN Posts P
ON PT.PostId = P.Id
WHERE P.PostTypeId = 1 --question
GROUP BY T.TagName
HAVING YEAR(MIN(P.CreationDate)) IN (2021,2022,2023)
ORDER BY YEAR(MIN(P.CreationDate))

fork query

edited nov 7

created nov 7 anonymous