จำนวนโพสต์สำหรับผู้ใช้ที่ถูกระงับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of posts for suspended users.It is not neccessary to use all the tables.
 Comments:  Id [ number]  PostId [ number]  Score [ number]  Text [ text]  CreationDate [ time]  UserDisplayName [ text]  UserId [ number]  ContentLicense [ text] 
WITH CTE AS (SELECT UserId, COUNT(*) AS TotalBadges FROM Badges GROUP BY UserId) SELECT Users.Id AS "user_link", DisplayName, Reputation, TotalBadges, COUNT(Posts.Id) AS "count" FROM Users JOIN CTE ON Users.Id = CTE.UserId INNER JOIN Posts ON Users.Id = Posts.OwnerUserId WHERE Users.Reputation = 1 AND TotalBadges >= @minBadges GROUP BY Users.Id, DisplayName, Reputation, TotalBadges ORDER BY COUNT(Posts.Id) DESC, Users.Id