0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Ukrainian language

select A.Score + max(B.Score) as Score1 , A.Title from Posts A, Posts B 
where A.Id = B.ParentId 
 and A.PostTypeId = 1 and B.PostTypeId = 2  
group by A.Id, A.Score , A.Title  having A.Score + sum(B.Score) > 0
order by A.Score + sum(B.Score) desc

view current version

edited nov 15

created nov 15 anonymous