select PostTypeId, SUM(Score) from posts where id<50 group by PostTypeId

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arts and Crafts Meta

Q&A about the site for artists and crafters

select *, row_number() over (partition by PostTypeId order by PostTypeId) FROM
(
select Id, PostTypeId, SUM(Score) tmp_sum
from posts where id<50 group by Id,PostTypeId) tmp_tble

Enter Parameters

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