SELECT group_name, count(id) AS coupon_total FROM cms.tc_cinema_coupon WHERE group_name IN ('Z20161031112508','Z2' ) AND STATUS = 0 GROUP BY group_name
SELECT group_name, count(id) AS coupon_total FROM cms.tc_cinema_coupon WHERE group_name IN ('Z20161031112508','Z2' ) AND STATUS = 0 GROUP BY group_name
转载于:https://www.cnblogs.com/xiaobiaomei/p/8073349.html