mybatis关于时间段的统计

<select id="getRequestCount" resultType="java.lang.Integer">
  //select sum(字段名），字段名 from 表名
  字段名 = addate(curdate(),xx)
        select SUM(request_count),request_date FROM statistics
        <where>
            /*昨天*/
            <if test="type == 1">
                request_date = ADDDATE(CURDATE(),-1)
            </if>
            /*最近7天*/
            <if test="type == 7">
                request_date BETWEEN ADDDATE(CURDATE(),-8) AND ADDDATE(CURDATE(),-1)
            </if>
            /*最近30天*/
            <if test="type == 30">
                request_date BETWEEN ADDDATE(CURDATE(),-31) AND ADDDATE(CURDATE(),-1)
            </if>
            /*最近1年*/
            <if test="type == 365">
                request_date BETWEEN ADDDATE(CURDATE(),-366) AND ADDDATE(CURDATE(),-1)
            </if>
            /*总共*/
            <if test="type == -1">
                1=1
            </if>
        </where>
    </select>