การกระจายแท็กบนแท็กกฎหมายที่สำคัญที่ไม่เกี่ยวข้องกับกฎหมาย ไม่จำเป็นต้องใช้ตารางทั้งหมด
tags distribution on the major legal tags non-legal related.It is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
SELECT t.TagName, COUNT(*) AS "number_of_question" FROM PostTags AS pt INNER JOIN PostTags AS bpt ON pt.PostId = bpt.PostId INNER JOIN Tags AS bt ON bt.Id = bpt.TagId INNER JOIN Tags AS t ON t.Id = pt.TagId AND t.Id != bt.Id WHERE bt.TagName = '##tag##' AND t.TagName NOT IN ('licensing', 'gpl', 'open-source', 'lgpl', 'legal', 'mit-license', 'apache-license', 'commercial', 'gplv3', 'license-key', 'bsd-license') GROUP BY t.TagName ORDER BY COUNT(*) DESC LIMIT 100