SFF ยอดดูและคะแนนคำตอบสำหรับแท็กหมวดหมู่ ID ยอดนิยม ไม่จำเป็นต้องใช้ตารางทั้งหมด
SFF Top Views and Answer Score for Top ID Category Tags.It is not neccessary to use all the tables.
 PostTags:  PostId [ number]  TagId [ number] 
WITH Questions AS (SELECT *, (SELECT SUM(A.Score) FROM Posts AS A WHERE A.ParentId = Q.Id) AS "answerscore" FROM Posts AS Q WHERE Q.PostTypeId = 1) SELECT 'All' AS "questions", ROUND(AVG(CAST(ViewCount AS FLOAT)), 0) AS "views", ROUND(AVG(CAST(AnswerCount AS FLOAT)), 2) AS "answers", ROUND(AVG(CAST(AnswerScore AS FLOAT) / CAST(AnswerCount AS FLOAT)), 2) AS "answer_score" FROM Questions UNION SELECT 'ID' AS "questions", ROUND(AVG(CAST(ViewCount AS FLOAT)), 0) AS "views", ROUND(AVG(CAST(AnswerCount AS FLOAT)), 2) AS "answers", ROUND(AVG(CAST(AnswerScore AS FLOAT) / CAST(AnswerCount AS FLOAT)), 2) AS "answer_score" FROM Questions WHERE Tags LIKE '%identification%'