mybatis plus实现使用聚合函数，group by分组

此处以OrderPayTrace表中根据支付类型的不同，统计金额总和为例，并且还可以根据创建时间段来查询筛选。

		QueryWrapper<OrderPayTrace> queryWrapper = new QueryWrapper<>();
        queryWrapper.select("type as 'type',IFNULL(sum(amount),0) as 'amountSum'")
                .between(!StringUtils.isEmpty(startCreateAt) && !StringUtils.isEmpty(endCreateAt), "create_at", startCreateAt, endCreateAt)
                .groupBy("type");
        List<Map<String, Object>> mapList = this.listMaps(queryWrapper);        

上述代码相当于下列sql语句

SELECT type as type,IFNULL(sum(amount),0) as amountSum
FROM order_pay_trace
WHERE create_at BETWEEN startCreateAt AND endCreateAt
GROUP BY type