select A.Score + sum(B.Score) as Score1 , A.Title from Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select A.Score + sum(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

Enter Parameters

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