sum 统计 SQL 实例

select sum(temp.times),sum(temp.c) from (select
      t.work_id releaserWorkId,
      t.real_name releaserName,
      t.nick_name releaserNickName,
      count(1) c,
      round(ifnull(sum(t.times),0),2) times
    from commonwealtime t
    where t.state = 0 and t.isdel=0
    AND gmt_create BETWEEN '2017-04-01'
    AND '2018-03-31 23:59:59'
    group by t.work_id
    order by times desc) temp;