Q&A for speakers of other languages learning English
select posttypeid, SUM(score), posttypes.name from posts join posttypes on posts.posttypeid = posttypes.id group by posttypeid, posttypes.name