MySQL 统计购买特定商品的唯一客户

Question

tbl_产品

+-------+---------+---------+
|  id   |  item   | Customer|
+-------+---------+---------+
|   1   |  Apple  | brad    |
|   2   |  Apple  | alex    |
|   3   |  Apple  | brad    |
|   4   |  Apple  | brad    |
|   5   |  Apple  | tim     |
|   6   |  Orange | brad    |
|   7   |  Orange | steve   |
|   8   |  Orange | alex    |
+-------+---------+---------+

有多少独立客户购买了 Apple？答案应该是:苹果3

Answer 1

试试这个:

SELECT COUNT(DISTINCT Customer)
FROM tbl_products
WHERE  item ='Apple'