Q&A about the site for artists and crafters
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