查询某时间范围内的值——sql

       SELECT
        project_id as project,
        SUM(account) count,
        spend_type as spendType
        FROM
        zj_bookkeeping
        WHERE
        deleted='0' <![CDATA[
        AND	billing_time >= #{StartingTime}
        AND billing_time  <= #{EndTime} ]]>
        GROUP BY
        project,spendType