Prueba 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT t.TagName, count(p.id) as cant_preguntas
FROM Tags t
JOIN PostTags pt on t.id = pt.TagId
JOIN Posts p on p.id = pt.PostId
JOIN Users u on p.OwnerUserId = u.id
JOIN Badges b on u.id = b.UserId
WHERE u.id = 5788
AND p.tags IS NOT NULL
AND YEAR(b.date) > 2022
GROUP BY t.TagName
ORDER BY cant_preguntas DESC

Enter Parameters

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