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