Q&A for scientists using computers to solve scientific problems
SELECT p.tags,COUNT(p.id) as cant_preguntas FROM Posts p JOIN PostHistory h ON p.id = h.PostId JOIN Users u ON u.id = h.UserId and u.DisplayName = h.userDisplayName WHERE u.id = 5788 AND p.ParentId IS NOT NULL AND h.CreationDate > 2022 GROUP BY p.tags ORDER BY cant_preguntas DESC