SELECT TOP 5 a.Id, COUNT(b.Id) as Vote_Count FROM Posts ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

SELECT TOP 5 a.Id, COUNT(b.Id) as Vote_Count

FROM Posts as a

INNER JOIN Votes as b
ON a.Id = b.PostId

WHERE YEAR(a.CreationDate) = 2018
AND b.VoteTypeId = 2

GROUP BY
a.Id

ORDER BY COUNT(b.Id) DESC

Enter Parameters

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