MySQL高阶2082-富有客户的数量
目录
题目
准备数据
分析数据
题目
编写解决方案找出 至少有一个 订单的金额 严格大于 500 的客户的数量。
准备数据
Create table If Not Exists Store (bill_id int, customer_id int, amount int)
Truncate table Store
insert into Store (bill_id, customer_id, amount) values ('6', '1', '549')
insert into Store (bill_id, customer_id, amount) values ('8', '1', '834')
insert into Store (bill_id, customer_id, amount) values ('4', '2', '394')
insert into Store (bill_id, customer_id, amount) values ('11', '3', '657')
insert into Store (bill_id, customer_id, amount) values ('13', '3', '257')
分析数据
select count( distinct customer_id) rich_count
from store
where amount > 500;