<select id="getTodayNum" resultType="java.util.Map">
SELECT COUNT(*) num
FROM whistle_case w
WHERE w.town = #{code}
AND DATEDIFF(w.create_date, NOW()) = 0
</select>
<select id="getYestodayNum" resultType="java.util.Map">
SELECT COUNT(*) num
FROM whistle_case w
WHERE w.town = #{code}
AND DATEDIFF(w.create_date, NOW()) = -1
</select>