instruction: This query gets a list of user links who have at least 5 Posts with a score of -5 or lower ordered by the amount of Posts that meet the above criteria.. This query gets a list of user links who have at least 5 Posts with a score of -5 or lower ordered by the amount of Posts that meet the above criteria.
response: SELECT CONCAT('http://stackoverflow.com/users/', p.OwnerUserId) AS "User Link", COUNT(p.Id) AS PostCount FROM Posts AS p JOIN PostTypes AS pt ON pt.Id = p.PostTypeId WHERE p.Score < -5 AND pt.Name IN ('Answer', 'Question') AND NOT p.OwnerUserId IS NULL GROUP BY p.OwnerUserId HAVING COUNT(p.Id) > 5 ORDER BY PostCount DESC