ผู้ใช้ที่มีคำตอบที่ไม่ใช่ CW ในแท็กส่วนใหญ่ (รวมถึงผู้ใช้ที่ถูกลบ) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Users with non-CW answers in most tags (including deleted users).It is not neccessary to use all the tables.
 Users:  Id [ number]  Reputation [ number]  CreationDate [ time]  DisplayName [ text]  LastAccessDate [ time]  WebsiteUrl [ text]  Location [ text]  AboutMe [ text]  Views [ number]  UpVotes [ number]  DownVotes [ number]  ProfileImageUrl [ text]  EmailHash [ text]  AccountId [ number] 
SELECT RANK() OVER (ORDER BY COUNT(DISTINCT pt.TagId) DESC) AS Rank, a.OwnerUserId AS "user_link", a.OwnerDisplayName, COUNT(DISTINCT pt.TagId) AS "#_of_tags" FROM Posts AS a INNER JOIN Posts AS q ON a.ParentId = q.Id INNER JOIN PostTags AS pt ON pt.PostId = q.Id WHERE (a.CommunityOwnedDate IS NULL) GROUP BY a.OwnerUserId, a.OwnerDisplayName ORDER BY COUNT(DISTINCT pt.TagId) DESC LIMIT 100