select A.Score + max(B.Score) as Score1 , A.Title, A.Crea...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

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

select A.Score + max(B.Score) as Score1 , A.Title, A.CreationDate from Posts A, Posts B 
where A.Id = B.ParentId 
 and A.PostTypeId = 1 and B.PostTypeId = 2  and A.Title like '%bayes%' 
group by A.Id, A.Score , A.Title , A.CreationDate
order by A.Score + sum(B.Score) desc

Enter Parameters

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