insert into region values 
(1, 'Europe'), 
(2,'North America'),
(3, 'South America'),
(4, 'Middle East'),
(5, 'Far East'),
(6, 'Asia'),
(7, 'Australia/Newzealand'),
(8, 'Africa');

insert into nation values
(1, 'Germany', 1),
(2, 'France', 1),
(3, 'Great Britain', 1),
(4, 'USA', 2),
(5, 'Italy', 1),
(6, 'Norway', 1),
(7, 'Japan', 5),
(8, 'India', 6),
(9, 'Australia', 7),
(10, 'Newzealand', 7),
(11, 'Mexico', 3),
(12, 'Israel', 4),
(13, 'Brasil', 3),
(14, 'Maroque', 8),
(15, 'South Africa', 8),
(16, 'Egypt', 8);

insert into customer values
(1, 'Mayer & Co.', 'Bluemchenstr. 12, 90153 Stuttgart', 1, '0851/987654', '0851/987650', 0.00),
(2, 'De la Croix', '261 Rue Lafayette, 10059 Paris', 2, '32662-23626-15', NULL,0.00),
(3, 'Myers & Sonss Ltd.', '819 Highstreet, LO2SW5 London', 3, '8716-18258', '8716-98385', 0.00),
(4, 'Jeffersons', '7159, Marketstreet, CA1825 SFO', 4, '1829298292', '18002762', 0.00),
(5, 'di Valli', 'Via Lunga 1, 1000 Roma', 5, '195 134 111', NULL, 0.00), 
(6, 'Svensson Heuser un Meer', 'Danskeveg 14, 51562 Oslo', 6, '12612672', '12612670', 0.00),
(7, 'Hochtiefbau AG', 'Adenauerallee 17, 22926 Hamburg', 1, '012/288600', NULL, 0.00),
(8, 'Happy Build', '6145, Washington Drive, N.Y.', 4, '18286019296', NULL, 0.00),
(9, 'Schneider & Pleite', 'Geierweg 5, 70275 Frankfurt a.M.', 1, '049/2828010', '049/28280101', -5000000000.00),
(10, 'Dupont', '45 Rue de Gaulle, 82961 Lyon', 2, '1092-29826-29', NULL, 0.00),
(11, 'Nippon Buildings', '19 St. Kutake yo 19156 Tokio', 7, '186-8373392', '186-83733900', 0.00),
(12, 'Lorena Inc.', 'La Jolla 1563, 81286 Brasilia', 13, '4582/87186982', NULL, 0.00), 
(13, 'New Land Building Comp.', '826 Unity Drv. 18283 Johannesburg', 15, '8186/9286', NULL, 0.00),
(14, 'Origins', '162, 5th-Street, Q193A5 Sydney', 9, '9871-18276', '9871-001', 0.00),
(15, 'Larini', 'Piazza dei Signori, 198125 Firenze', 5, '196 285 859', NULL, 0.00),
(16, 'Cooper & Cooper Ltd.', '195 St. Martin Rd., MA1959 Manchester', 3, '2859-93962', NULL, 0.00),
(17, 'Ahmet Halil', '195 Kourfia Street, QG195 Kairo', 16, '1001987', NULL, 0.00),
(18, 'XTREME INC.', '19600 Broadway, CA1511 L.A.', 4, '8381036-196', '8381036-1', 0.00),
(19, 'Walter & Soehne', 'Waldweg 3, 59195 Trier', 1, '0581/98916', '0581/983834', 0.00),
(20, 'Hishuyaki Ltd.', '72 St. Kuyotake 39762 Osaka', 7, '199-029692696', '199-029600', 0.00),
(21, 'Bestelltnix GmbH', 'Wucherweg 77, 87237 Teuerdorf', 1, '08715/1234', NULL, 0.00),
(22, 'Eisenwaren Huber', 'Industriestr. 1, 82961 Germering', 1, '08175/919260', '08175/919261', 0.00),
(23, 'HUI Company & Co.', 'Gruene Allee 16, 19861 Hamburg', 1, '0186/18586', NULL, 0.00);

insert into part values
(1, 'Twistfix04', 'Schraube', 4, 100, 18.50),
(2, 'Twistfix06', 'Schraube', 6, 50, 17.50),
(3, 'Turbo2000', 'Bohrer', 4, 20, 63.75),
(4, 'Hui 10758', 'Bohrer', 4, 10, 25.00),
(5, 'Hui 23551', 'Schleifer', NULL, 1, 156.20),
(6, 'Swirli E264 super', 'Industriestaubsauger', NULL, 1, 399.00),
(7, 'EH 6381Fe', 'Eisenhammer', 3, 5, 30.00),
(8, 'Fix2000 N5', 'Nagel', 5, 100, 13.40),
(9, 'Fix2000 N2', 'Nagel', 2, 500, 48.27),
(10, 'S87904', 'Schraube', 4, 150, 20.00),
(11, 'S87904', 'Schraube', 2, 250, 25.00),
(12, 'St4576 Super KO', 'Stahltraeger T', 25, 1, 2479.00),
(13, 'St2615 Standard', 'Stahltraeger T', 17, 1, 1794.80),
(14, 'St1324 Extra', 'Stahlverstrebung', 100, 1, 5798.77),
(15, 'Twistfix10', 'Schraube', 10, 25, 20.00),
(16, 'Megalaerm', 'Presslufthammer', NULL, 1, 1600.00),
(17, 'Megalaerm', 'Mischmaschine', NULL, 1, 5261.87),
(18, 'Matsch100', 'Zementmischung', 25, 10, 543.50),
(19, 'Matsch100', 'Zementmischung', 50, 10, 980.20),
(20, 'Supermatsch Extra', 'Zementmischung', 50, 10, 1567.90),
(21, 'Twistfix04', 'Schraube', 4, 50, 10.00);


insert into supplier values
(1, 'Twistfix', 'Schraubenweg 42, 81920 Muenchen', 1, '089/8175619', NULL, 0.00),
(2, 'TURBOhrmaschinen', 'Hauptstr. 161, 98267 Stuttgart', 1, '0916/188621', '0916/188622', 0.00),
(3, 'HUI Company & Co.', 'Gruene Allee 16, 19861 Hamburg', 1, '0186/18586', NULL, 0.00),
(4, 'SWIRL', 'Alte Gasse 1, 81866 Muenchen', 1, '089/918692', NULL, 0.00),
(5, 'Eisenwaren Huber', 'Industriestr. 1, 82961 Germering', 1, '08175/919260', '08175/919261', 0.00),
(6, 'Fix & Fertig AG', 'Naegelestr. 93, 45366 Oberhausen', 1, '0425/81862', NULL, 0.00),
(7, 'Screws & more', 'Bahnhofstr.89, 91265 Reutlingen', 1, '0971/8189602', '0971/8127624', 0.00),
(8, 'Thyssen Stahl', '69296 Bochum', 1, '0694/1996 - 00', NULL, 0.00),
(9, 'MEGA-Maschinen', 'Neue Strasse 25, 02062 Dresden', 1, '0015/981853', NULL, 0.00),
(10, 'Matsch Zementwerke', 'Im Schlamm 15, 91962 Hinterdorfen', 1, '09918/81885', '09918/777', 0.00);

insert into partsupp values
(1, 1, 20000, 0.00),
(2, 1, 45000, 0.00),
(3, 2, 1500, 2.00),
(4, 3, 13500, 1.50),
(5, 3, 2780, 2.30),
(6, 4, 5000, 4.00),
(7, 5, 54904, 0.00),
(8, 6, 80000, 0.00),
(9, 6, 350000, 0.00),
(10, 7, 67045, 0.00),
(11, 7, 279650, 0.00),
(12, 8, 20000, 350.00),
(13, 8, 12000, 300.00),
(14, 8, 400, 500.00),
(15, 1, 89400, 0.00),
(16, 9, 600, 120.00),
(17, 9, 200, 50.00),
(18, 10, 500000, 3.50),
(19, 10, 450000, 3.50),
(20, 10, 250000, 3.50),
(21, 1, 250000, 0.00);

insert into order values
(1, 2, 'no', +0000000068923.44, '1997-11-27'),
(2, 16, 'ok', +0000000000956.25, '1996-12-01'),
(3, 4, 'ok', +0000000001357.00, '1995-01-30'),
(4, 1, 'no', +0000000057987.70, '1998-02-05'),
(5, 5, 'ok', +0000000012395.00, '1997-05-19'),
(6, 8, 'ok', +0000000027363.75, '1997-09-21'),
(7, 3, 'ok', +0000000000125.00, '1997-07-21'),
(8, 17, 'ok', +0000000001562.00, '1995-04-03'),
(9, 11, 'ok', +0000000000175.00, '1996-03-25'),
(10, 1, 'no', +0000000000237.00, '1997-10-28'),
(11, 12, 'ok', +0000000000125.00, '1996-10-14'),
(12, 7, 'ok', +0000000026309.35, '1995-10-24'),
(13, 3, 'ok', +0000000103360.00, '1997-08-20'),
(14, 2, 'ok', +0000000035896.00, '1997-02-06'),
(15, 4, 'ok', +0000000000185.00, '1998-03-26'),
(16, 5, 'no', +0000000527749.00, '1997-11-14'),
(17, 20, 'ok', +0000000002479.00, '1996-01-18'),
(18, 13, 'ok', +0000000000125.00, '1996-12-22'),
(19, 15, 'ok', +0000000000480.00, '1996-10-08'),
(20, 9, 'ok', +0000000002479.00, '1997-12-28'),
(21, 6, 'ok', +0000000302333.50, '1995-09-01'),
(22, 19, 'no', +0000000017948.00, '1997-09-01'),
(23, 6, 'ok', +0000000062720.70, '1997-08-31'),
(24, 7, 'ok', +0000000000318.75, '1996-06-07'),
(25, 10, 'ok', +0000000010600.00, '1997-05-19'),
(26, 14, 'ok', +0000000073081.00, '1997-11-10'),
(27, 10, 'no', +0000000000185.00, '1998-01-08'),
(28, 9, 'ok', +0000000000127.50, '1997-04-15'),
(29, 18, 'ok', +0000000000200.00, '1997-07-18'),
(30, 8, 'ok', +0000000001600.00, '1996-03-11'),
(31, 1, 'no', +0000000052618.70, '1997-11-12'),
(32, 3, 'ok', +0000000000875.00, '1996-02-06'),
(33, 11, 'ok', +0000000000160.00, '1996-08-14'),
(34, 7, 'ok', +0000000009802.00, '1997-06-27'),
(35, 5, 'ok', +0000000017948.00, '1994-05-30'),
(36, 20, 'no', +0000000000037.00, '1998-01-04'),
(37, 22, 'no', +0000000008850.00, '1998-05-02'),
(100, 9, 'no', +0000000020872.66, '1998-05-18');


insert into lineitem values
(1, 10, 7, 1, 50, +0000000005000.00, NULL, NULL),
(1, 17, 9, 2, 12, +0000000063142.44, NULL, NULL),
(1, 5, 3, 3, 5, +0000000000781.00, NULL, NULL),
(2, 3, 2, 1, 15, +0000000000956.25, NULL, NULL),
(3, 6, 4, 1, 3, +0000000001197.00, NULL, NULL),
(3, 16, 9, 2, 1, +0000000000160.00, NULL, NULL),
(4, 14, 8, 1, 10, +0000000057987.70, NULL, NULL),
(5, 12, 8, 1, 5, +0000000012395.00, NULL, NULL),
(6, 8, 6, 1, 100, +0000000001340.00, NULL, NULL),
(6, 19, 10, 2, 25, +0000000025705.00, NULL, NULL),
(6, 3, 2, 3, 5, +0000000000318.75, NULL, NULL),
(7, 11, 7, 1, 5, +0000000000125.00, NULL, NULL),
(8, 5, 3, 1, 10, +0000000001562.00, NULL, NULL),
(9, 2, 1, 1, 100, +0000000000175.00, NULL, NULL),
(10, 1, 1, 1, 20, +0000000000037.00, NULL, NULL),
(10, 15, 1, 2, 100, +0000000000200.00, NULL, NULL),
(11, 4, 3, 1, 5, +0000000000125.00, NULL, NULL),
(12, 17, 9, 1, 5, +0000000026309.35, NULL, NULL),
(13, 18, 10, 1, 1000, +0000000054350.00, NULL, NULL),
(13, 19, 10, 2, 500, +0000000049010.00, NULL, NULL),
(14, 13, 8, 1, 20, +0000000035896.00, NULL, NULL),
(15, 1, 1, 1, 100, +0000000000185.00, NULL, NULL),
(16, 5, 3, 1, 100, +0000000001562.00, NULL, NULL),
(16, 17, 9, 2, 100, +0000000526187.00, NULL, NULL),
(17, 12, 8, 1, 10, +0000000002479.00, NULL, NULL),
(18, 11, 7, 1, 50, +0000000000125.00, NULL, NULL),
(19, 16, 9, 1, 3, +0000000000480.00, NULL, NULL),
(20, 12, 8, 1, 10, +0000000002479.00, NULL, NULL),
(21, 14, 8, 1, 50, +0000000289938.50, NULL, NULL),
(21, 12, 8, 2, 50, +0000000012395.00, NULL, NULL),
(22, 13, 8, 1, 100, +0000000017948.00, NULL, NULL),
(23, 4, 3, 1, 5, +0000000000125.00, NULL, NULL),
(23, 2, 1, 2, 100, +0000000000175.00, NULL, NULL),
(23, 17, 9, 3, 10, +0000000052618.70, NULL, NULL),
(23, 19, 10, 4, 100, +0000000009802.00, NULL, NULL),
(24, 3, 2, 1, 5, +0000000000318.75, NULL, NULL),
(25, 1, 1, 1, 1000, +0000000001850.00, NULL, NULL),
(25, 2, 1, 2, 500, +0000000008750.00, NULL, NULL),
(26, 12, 8, 1, 15, +0000000037185.00, NULL, NULL),
(26, 13, 8, 2, 20, +0000000035896.00, NULL, NULL),
(27, 1, 1, 1, 10, +0000000000185.00, NULL, NULL),
(28, 3, 2, 1, 1, +0000000000127.50, NULL, NULL),
(29, 15, 1, 1, 100, +0000000000200.00, NULL, NULL),
(30, 16, 9, 1, 10, +0000000001600.00, NULL, NULL),
(31, 17, 9, 1, 10, +0000000052618.70, NULL, NULL),
(32, 2, 1, 1, 50, +0000000000875.00, NULL, NULL),
(33, 16, 9, 1, 1, +0000000000160.00, NULL, NULL),
(34, 19, 10, 1, 100, +0000000009802.00, NULL, NULL),
(35, 13, 8, 1, 10, +0000000017948.00, NULL, NULL),
(36, 1, 1, 1, 20, +0000000000037.00, NULL, NULL),
(37, 15, 1, 1, 50, +0000000000100.00, NULL, NULL),
(37, 2, 1, 2, 500, +0000000008750.00, NULL, NULL),
(100, 1, 1, 1, 1, +0000000000018.50, NULL, NULL),
(100, 2, 1, 2, 1, +0000000000017.50, NULL, NULL),
(100, 3, 2, 3, 1, +0000000000063.75, NULL, NULL),
(100, 4, 3, 4, 1, +0000000000025.00, NULL, NULL),
(100, 5, 3, 5, 1, +0000000000156.20, NULL, NULL),
(100, 6, 4, 6, 1, +0000000000399.00, NULL, NULL),
(100, 7, 5, 7, 1, +0000000000030.00, NULL, NULL),
(100, 8, 6, 8, 1, +0000000000013.40, NULL, NULL),
(100, 9, 6, 9, 1, +0000000000048.27, NULL, NULL),
(100, 10, 7, 10, 1, +0000000000020.00, NULL, NULL),
(100, 11, 7, 11, 1, +0000000000025.00, NULL, NULL),
(100, 12, 8, 12, 1, +0000000002479.00, NULL, NULL),
(100, 13, 8, 13, 1, +0000000001794.80, NULL, NULL),
(100, 14, 8, 14, 1, +0000000005798.77, NULL, NULL),
(100, 15, 1, 15, 1, +0000000000020.00, NULL, NULL),
(100, 16, 9, 16, 1, +0000000001600.00, NULL, NULL),
(100, 17, 9, 17, 1, +0000000005261.87, NULL, NULL),
(100, 18, 10, 18, 1, +0000000000543.50, NULL, NULL),
(100, 19, 10, 19, 1, +0000000000980.20, NULL, NULL),
(100, 20, 10, 20, 1, +0000000001567.90, NULL, NULL),
(100, 21, 1, 21, 1, +0000000000010.00, NULL, NULL);