<!-- 演示分组汇总 -->
<sql id="qstart_group_summary_case">
    <value>
    <![CDATA[
    select t.fruit_name,t.order_month,t.sale_count,t.sale_price,t.total_amt 
    from sqltoy_fruit_order t
    order by t.fruit_name ,t.order_month
    ]]>
    </value>
    <!-- 5.1.26 版本开始支持求平均过滤掉null值 -->
    <summary sum-columns="sale_count,total_amt" average-columns="sale_price" average-skip-null="true"
			reverse="true">
        <!-- 层级顺序保持从高到低 -->
        <global sum-label="总计" label-column="fruit_name" reverse="true"/>
        <group group-column="fruit_name" sum-label="小计"
				label-column="fruit_name" />
    </summary>
</sql>

<dependency>
	<groupId>com.sagframe</groupId>
	<artifactId>sagacity-sqltoy</artifactId>
	<version>5.1.26</version>
</dependency>
<dependency>
	<groupId>com.sagframe</groupId>
	<artifactId>sagacity-sqltoy-starter</artifactId>
	<version>5.1.26</version>
</dependency>