我有一张名为“ sales”的表。
create table sales
(
cust varchar(20),prod varchar(20),day integer,month integer,year integer,state char(2),quant integer
);
insert into sales values ('Bloom','Pepsi',2,12,2001,'NY',4232);
insert into sales values ('Knuth','Bread',23,5,2005,'PA',4167);
insert into sales values ('Emily',22,1,2006,'CT',4404);
insert into sales values ('Emily','Fruits',11,2000,'NJ',4369);
insert into sales values ('Helen','Milk',7,210);
insert into sales values ('Emily','Soap',4,2002,2549);
insert into sales values ('Bloom','Eggs',30,559);
..共有498行。这是此表的概述:
现在我想获得每个月客户和产品组合购买了销售数量的2/3的月份。
结果应如下所示:
有人想帮助我吗?