查询某时间范围内的值

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