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没值

不显示