แท็กยอดนิยมที่เกี่ยวข้องกับ Java และ SSH ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top tags related to Java and SSH.It is not neccessary to use all the tables.
 SuggestedEdits:  Id [ number]  PostId [ number]  CreationDate [ time]  ApprovalDate [ time]  RejectionDate [ time]  OwnerUserId [ number]  Comment [ text]  Text [ text]  Title [ text]  Tags [ text]  RevisionGUID [ other] 
SELECT t.TagName, COUNT(*) AS count FROM PostTags AS pt, Tags AS t, PostTags AS ptjs WHERE pt.TagId = t.Id AND pt.PostId = ptjs.PostId AND ptjs.TagId = (SELECT Id FROM Tags WHERE LOWER(TagName) = 'javascript') GROUP BY t.TagName ORDER BY Count DESC