set names big5;

drop table fruit;

create table fruit
   (
   odate date,
   cno   varchar(3),
   cname varchar(4),
   area  varchar(4),
   fee   integer(3),
   pno   varchar(3),
   pname varchar(4),
   price integer(3),
   qty   integer(3),
   amt   integer(4)
   );

insert into fruit values ('2008-11-03','C01','李四','台中', 100,'P01','西瓜',  50,  20,1100);
insert into fruit values ('2008-11-05','C01','李四','台中', 100,'P01','西瓜',  50, 100,5100);
insert into fruit values (null,         null, null , null ,null,'P02','蘋果',  80,null,null);
insert into fruit values ('2008-11-03','C01','李四','台中', 100,'P03','鳳梨',  40, 100,4100);
insert into fruit values (null,        'C02','丁一','台南',   0,null , null ,null,null,null);
insert into fruit values ('2008-11-07','C03','王五','台北',  70,'P04','香蕉',  20,  20, 470);
insert into fruit values ('2008-11-08','C03','王五','台北',  70,'P04','香蕉',  20,  10, 270);
insert into fruit values ('2008-11-08','C04','張三','高雄',  30,'P03','鳳梨',  40,  20, 830);
insert into fruit values ('2008-11-07','C04','張三','高雄',  30,'P04','香蕉',  20,  20, 430);
insert into fruit values (null,        'C05','劉三','台南',   0,null , null ,null,null,null);
insert into fruit values (null,         null, null ,'澎湖',null,null , null ,null,null,null);
insert into fruit values (null,         null, null ,'花蓮',  50,null , null ,null,null,null);
insert into fruit values (null,         null, null ,null,  null,'P05','楊桃',  10,null,null);