คำตอบทั้งหมดและคำตอบที่ยอมรับตามวันที่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Total answers and Accepted Answers By Date.It is not neccessary to use all the tables.
 PostTags:  PostId [ number]  TagId [ number] 
SELECT Users.DisplayName AS "user_name", 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 AND answer.CreationDate BETWEEN '2015-01-01 00:00:00' AND '2015-12-31 00:00:00' GROUP BY answer.OwnerUserId, Users.Reputation, Users.DisplayName