聚合函数查询二销产品可用次数之和、已使用次数之和、以及剩余可用次数
SELECT
sec_consume_product_base_id,
SUM(can_use_times) AS '可用次数',
SUM(use_times) AS '已使用次数',
SUM(can_use_times) - SUM(use_times) AS '剩余可用'
FROM
ticket_play_item_package
WHERE ticket_no = '11111111111111'
AND additional_type = "1"
AND `status` > 1
GROUP BY sec_consume_product_base_id
此处的sec_consume_product_base_id是一的一方