0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT
  Question.Id,
  COUNT(QuestionVotes.Id) as QuestionUpVotes
  

FROM Posts AS Question
JOIN Votes AS QuestionVotes ON (QuestionVotes.PostId = Question.Id AND QuestionVotes.VoteTypeId = 2)

WHERE Question.PostTypeId = 1 -- Question
  AND (Question.Tags LIKE '%<amazon-%' OR Question.Tags LIKE '%<aws-%')
  AND AcceptedAnswerId IS NOT NULL
  AND Question.Id = 59587972

GROUP BY Question.Id

fork query

created apr 22 20 John Rotenstein