Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática
SELECT p.Id, vt.Id, count(*) AS cnt -- , RANK() OVER (partition by (p.Id) -- ORDER BY count(*)) AS Rank FROM Posts p JOIN Votes v ON p.Id = v.PostId JOIN VoteTypes vt ON v.VoteTypeId = vt.Id WHERE vt.Id IN (2) GROUP BY p.Id, vt.Id ORDER BY count(*)