create table car
(cid character (10),
 model character(10),
 price integer
);
create table service
(sid integer,
 name character (20),
 area character (6),
 tel character (16),
 addr character (50)
);
create table sale
(mon integer,
 sid integer,
 cid character (10),
 num integer
);
insert into car values ('c1','318i',168);
insert into car values ('c2','320i',198);
insert into car values ('c3','330i',241);
insert into car values ('c4','318ci',190);
insert into car values ('c5','320ci',211);
insert into car values ('c6','325ci',227);
insert into car values ('c7','330ci',251);
insert into car values ('c8','520i',293);
insert into car values ('c9','525i',293);
insert into car values ('c10','530i',333);
insert into car values ('c11','545i',400);
insert into car values ('c12','645ci',489);
insert into car values ('c13','730i',359);
insert into car values ('c14','735i',405);
insert into car values ('c15','735li',445);
insert into car values ('c16','745i',489);
insert into car values ('c17','745li',519);
insert into car values ('c18','760li',730);
insert into service values (1,'敦南展示中心','北區','(02)2738-0123','台北市敦化南路二段333號1F');
insert into service values (2,'天母展示中心','北區','(02)2838-1516','台北市中山北路六段76號');
insert into service values (3,'BMW時尚生活館','北區','(07)355-2046','高雄SOGO百貨 高雄市三多三路217號');
insert into service values (4,'文心展示中心','中區','(04)2252-0303','台中市文心路一段463號');
insert into service values (5,'彰化展示中心','中區','(04)787-0620','彰化縣花壇鄉中山路二段498-1號');
insert into service values (6,'花蓮展示中心','中區','(038)541-155','花蓮縣吉安鄉中央路三段312號');
insert into service values (7,'嘉義展示中心','南區','(05)237-2255','嘉義市北港路800號之2');
insert into service values (8,'永華路展示中心','南區','(06)299-4850','台南市永華路二段456號');
insert into service values (9,'博愛路展示中心','南區','(07)341-1300','高雄市博愛三路582號');
insert into sale values (1,3,'c13',6);
insert into sale values (1,7,'c1',5);
insert into sale values (1,9,'c7',5);
insert into sale values (2,1,'c5',2);
insert into sale values (2,4,'c18',1);
insert into sale values (2,3,'c2',3);
insert into sale values (2,5,'c15',3);
insert into sale values (3,2,'c2',2);
insert into sale values (3,7,'c11',3);
insert into sale values (3,8,'c14',4);
insert into sale values (3,4,'c4',3);
insert into sale values (3,3,'c3',2);