select 科目,MAX(分数) from 表名 where group by 科目 select Customer, Sum(OrderPrice) from 表名 where group by Customer