java mybatis 查询语句group by写法以及返回值

mapper接口

    /**
     * @description: 得到折线图的纵坐标 ydata
     *
     * @author 何帆
     * @date 2023/2/6 10:16
     * @param pigstyId
     * @param beginDate
     * @param endDate
     * @return java.util.List<com.infoex.pojo.communication.InventoryBlow>
     */
    List<Map<String, Object>> getChartByPigstyIdAndDate(@Param("pigstyId") Long pigstyId,
                                                           @Param("beginDate") Date beginDate,
                                                           @Param("endDate") Date endDate);

sql

    <select id="getChartByPigstyIdAndDate" resultType="java.util.Map">
        SELECT
            create_time, SUM(num) as nums
        FROM
            inventory_blow
        WHERE
            pigsty_id = #{pigstyId}
          AND ( add_time BETWEEN #{beginDate} AND #{endDate} )
        GROUP BY
            create_time
        ORDER BY
            create_time ASC
    </select>

注意:查出来的返回值为List<Map<String, Object>>

另外,ORDER BY的属性必须是查询的