count()
SELECT cb.commodity_id, cb.group_name, count(cc.id) AS coupon_total FROM cms.tc_cinema_coupon AS cc JOIN cms.tc_commodity_batch AS cb ON cb.group_name = cc.group_name WHERE cc.group_name IN ('Z20161031112508', 'TEST_1') AND cc. STATUS = 0 GROUP BY cc.group_name
1.count有值
2.count没值
不显示