Answer Count by User and Tag Since Date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT COUNT(Answers.Id) AS [Answer Count], 
SUM(Answers.Score) AS [Total Score],
SUM(Questions.ViewCount) AS Views

FROM Posts as Answers, Posts as Questions

WHERE Questions.Id = Answers.ParentId
AND Answers.OwnerUserId = ##UserId## 
AND Questions.Tags like ##Tag:string?%amazon-web-services%##
AND Answers.CreationDate >= ##StartDate:string?2019-01-01##

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results