mysql 多计数与 WHERE

Question

我有以下查询:

 SELECT COUNT(*) AS item_count,
 reseller_id, count(**WHERE sold=1**) as sold_count
 count(**WHERE refunded=1**) as rrefunded
 FROM store GROUP BY
 reseller_id

售出为 1 或 0，退款相同。

我想查看每个经销商的销售量和退款量，但我不知道如何在一个查询中执行此操作。

Answer 1

如果它是 1 或 0 你可以做 SUM()

SELECT SUM(sold) as sold_count, SUM(refunded) as refund_count FROM store