with top_3_posts as ( select top 3 id from Users Order by...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

with top_3_posts as (
select top 3
id
from Users
Order by Views DESC
)

select
a.Id
,sum(a.Score)
from Posts a
inner join top_3_posts b on a.Id = b.Id
group by a.Id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results