分组函数

                   select     
               sa.areaCode       as "areaCode", 
               sa.areaScore      as "areaScore",
               sa.upload_year    as "uploadYear",
               sa.upload_quarter as "uploadQuarter",
               sa.credit_assess_template_id as "creditAssessTemplateId",
               a.name            as "areaName",
               a.id              as "areaId",
               pa.name       as "pAreaName"
         from (select t.area_code as areaCode,
                   sum(t.score) as areaScore,
                   t.upload_year,
                   t.upload_quarter,
                   t.credit_assess_template_id
             from credit_quality_grade_score_sum t
             group by t.area_code, 
                   t.upload_year, 
                   t.upload_quarter,
                   t.credit_assess_template_id
           ) sa,
           sys_area a,
           sys_area pa
     where a.code = sa.areaCode
           and a.type = 4
           and pa.id = a.parent_id

第一，分组函数 group by 把相同的分到一组
第二，分组函数 必须与前面的列名相同
第三，from (select * from A) sys_area B 看做一张大表