Q&A about the site for power users of web applications
SELECT DISTINCT p.Id AS [Post Link], p.CreationDate, p.Score, p.ViewCount, p.Tags, p.Title, u.Id AS UserId, b.Class AS BadgeClass FROM Posts p JOIN Users u ON p.OwnerUserId = u.Id JOIN Badges b ON u.Id = b.UserId WHERE p.PostTypeId = 1 -- Questions only AND p.AnswerCount = 0 -- No answers AND p.Score < 0 -- Negative score AND p.ClosedDate IS NULL -- Exclude closed questions AND u.Reputation >= 1 AND u.Reputation <= 1000 -- Reputation between 1 and 1000 AND b.Class = 3 -- Bronze badge (Class 3 represents bronze badges) AND p.CreationDate BETWEEN '2018-01-01' AND '2019-12-31' -- Posts between 2018 and 2019 ORDER BY p.CreationDate DESC;