s โดยแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
s, by tag.It is not neccessary to use all the tables.
 TagSynonyms:  Id [ number]  SourceTagName [ text]  TargetTagName [ text]  CreationDate [ time]  OwnerUserId [ number]  AutoRenameCount [ number]  LastAutoRename [ time]  Score [ number]  ApprovedByUserId [ number]  ApprovalDate [ time] 
SELECT *, CAST(100.0 * a.answered / a.total AS FLOAT(10, 2)) AS PercentAnswered FROM (SELECT t.TagName, SUM(CASE WHEN p.AnswerCount + p.CommentCount > 0 THEN 1 ELSE 0 END) AS answered, COUNT(p.Id) AS total FROM Posts AS p JOIN PostTags AS pTags ON pTags.PostId = p.Id JOIN Tags AS t ON pTags.TagId = t.Id GROUP BY t.TagName) AS a WHERE a.total > '##MinQuestions:int##' ORDER BY PercentAnswered DESC