จำนวนปิดทั้งหมด คำถามทั้งหมด อัตราส่วน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Total Closed, Total Questions, ratio.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 COUNT(*) AS TotalQuestions, (SELECT COUNT(*) AS TotalClosed FROM Posts AS C WHERE C.OwnerUserId = P.OwnerUserId AND ClosedDate != '' AND PostTypeId = 1) AS TotalClosed, (SELECT COUNT(*) AS TotalClosed FROM Posts AS C WHERE C.OwnerUserId = P.OwnerUserId AND ClosedDate != '' AND PostTypeId = 1) * 100.0 / COUNT(*) * 1.0 AS PercentClosed FROM Posts AS P WHERE P.OwnerUserId = '##UserId##' AND PostTypeId = 1 GROUP BY OwnerUserId