Q&A for experienced flyers, pilots, and builders of drones and model aircraft
select q.Id as [Post Link], q.score, a.score, count (v.Id) as DownVotes from Posts q inner join Posts a on q.AcceptedAnswerId = a.id and a.PostTypeId = 2 inner join votes v on q.Id = v.PostId and v.VoteTypeId = 3 where q.PostTypeId = 1 and q.ClosedDate is null and q.AcceptedAnswerId is not null group by q.Id, q.score, a.score