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


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 Id, PostTypeId from
select Id, PostTypeId, SUM(Score) tmp_sum, row_number() over (partition by PostTypeId order by PostTypeId) row_num
from posts where id<50  group by Id,PostTypeId
) tmp_table
where row_num < 4

Enter Parameters

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