select top 10 p.Id as [Post Link], p.Score as AnswerScore...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 10
 p.Id as [Post Link],
 p.Score as AnswerScore,
 q.Score as QuestionScore
from Posts p
inner join Posts q on q.Id = p.ParentId and q.Score < 0
where p.Score > 10
order by q.Score asc

Enter Parameters

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