คำตอบทั้งหมดและคำตอบที่ยอมรับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Total answers and Accepted Answers.It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT Users.DisplayName AS "user_name", 'http://stackoverflow.com/users/' + CAST(answer.OwnerUserId AS TEXT(10)) AS "permalink", Users.Reputation, SUM(COALESCE(question.ViewCount, 0)) AS reached, COUNT(DISTINCT answer.Id) AS "total_answers", COUNT(DISTINCT question.Id) AS "accepted_answers" FROM Posts AS answer LEFT OUTER JOIN Posts AS question ON question.AcceptedAnswerId = answer.Id INNER JOIN Users ON answer.OwnerUserId = Users.Id INNER JOIN PostTags ON answer.ParentId = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE answer.OwnerUserId IN ('##UserId##') AND answer.PostTypeId = 2 GROUP BY answer.CreationDate, answer.OwnerUserId, Users.Reputation, Users.DisplayName