查询先购买商品A后购买商品C的顾客，输出在购买A和购买C中间所有购买B的消费记录，如果未买C，则输出购买A后所有购买B的记录。
create table sales (
Customer char(20),
Goods char(20),
salesDate Date);
insert into sales values('001','C','2019-05-01');
insert into sales values('001','A','2020-01-01');
insert into sales values('001','B','2020-02-01');
insert into sales values('001','B','2020-05-01');
insert into sales values('001','C','2020-07-01');
insert into sales values('002','A','2020-02-01');
insert into sales values('002','B','2020-03-01');
insert into sales values('002','B','2020-10-01');
insert into sales values('003','A','2019-01-01');
insert into sales values('003','B','2020-03-12');
insert into sales values('003','C','2020-09-01');
insert into sales values('003','A','2020-10-01');
insert into sales values('003','B','2020-11-11');
insert into sales values('003','C','2020-12-31');
select * from sales;
评论 (0)
