Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems
SELECT TOP ##NumLines:int?100## "t"."TagName" AS "TagName", COUNT("PostId") AS "CountUnanswered", "t"."Count" AS "CountAll", 100*COUNT("PostId")/"t"."Count" AS "UnansweredPercents" FROM PostTags AS "pt" JOIN "Tags" AS "t" ON "t"."Id" = "pt"."TagId" INNER JOIN "Posts" AS "p" ON "p"."Id" = "pt"."PostId" WHERE "p"."AnswerCount" = 0 AND "p"."ClosedDate" IS NULL GROUP BY "pt"."TagId", "t"."TagName", "t"."Count" HAVING COUNT("PostId") >= ##MinQuestions:int?1## ORDER BY "CountUnanswered" DESC, "CountAll" DESC, "TagName" ASC