mySql统计某属性不同值的数量

查出结果是List<Map map> 
<select id="findRouteNumber" parameterType="com.besttop.logistics.model.bill.BillReturns"
        resultType="java.util.HashMap">
    SELECT
    route_code, COUNT(route_code IS NULL) AS COUNT
    FROM
    `bill_returns` WHERE
    del_flag = 0
    GROUP BY route_code;
</select>

统计逗号隔开字符串数量

SUM(LENGTH(invoice_bill_listing) - LENGTH(REPLACE(`invoice_bill_listing`, ',', '')) + 1)