0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

-- Enter Query Title
-- Enter Query Description

with Questions as (
select * from Posts
where ParentId is null
and Score = 0
and CommunityOwnedDate is null
)

select top 500 p.ParentId as [Post Link], sum(p.Score) as AnswerScore from Posts p
join Questions q on p.ParentId = q.Id
group by p.ParentId
order by AnswerScore desc

fork query

created jul 28 10 krock