SELECT T.TagName, MIN(P.CreationDate) AS FirstUseDt FROM ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

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)

Enter Parameters

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