mysql 查询多个类型多条数据并汇总

需求：查询多天的不同类型的每天最大的pv值  并 group by 每天的汇总量（即不同类型每天的相加总量）

由于环境需要，必须要这么做，在之前的基础上优化了下sql 一条就解决了：

子查询：

1：select max(total_gv) as max_total_gv,daytime from game

WHERE (restype=1 || restype=2) and (daytime BETWEEN 20160813 AND 20160819) group by 
     daytime,restype  order by daytime DESC

2：总的sql：

select sum(max_total_gv), daytime from (

select max(total_gv) as max_total_gv,daytime from game_exec   

WHERE (restype=1 || restype=2) and (daytime BETWEEN 20160813 AND 20160819) group by 

 daytime,restype  order by daytime DESC
 ) as a GROUP BY daytime;