0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

SELECT 
        p.OwnerUserId,
        pt.TagId,
        MIN(p.CreationDate) AS FirstTagUsageDate
    FROM posts p
    JOIN PostTags pt ON p.Id = pt.PostId
    WHERE p.PostTypeId = 1
    GROUP BY p.OwnerUserId, pt.TagId

view current version

edited sep 8

created sep 8 jon.doe45585