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 MIN(P.CreationDate)

fork query

edited nov 7

created nov 7 anonymous