0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

SELECT t.TagName, COUNT(1) AS total
FROM Posts p
JOIN PostTags pt ON pt.PostId = p.Id
JOIN Tags t ON t.Id = pt.TagId
WHERE t.tagName IN ('rsa', 'ecdsa', 'ed25519', 'dsa')
    AND p.CreationDate >= '1/1/2019'
GROUP BY t.TagName
ORDER BY total DESC;

fork query

edited aug 15 19

created aug 15 19 anonymous