ToyStoreOrder – A Toy Store and Orders

Paste this to create or re-create the database tables.

-- Toy Store Order Sample Database
-- Introduction to Database Systems Modeling and Administration
-- James M. Reneau Ph.D.
-- Version 2025-02-08
-- C) J.M.Reneau Ph.D. - All Rights Reserved

-- Create Database Tables Script

DROP TABLE IF EXISTS order_detail;
DROP TABLE IF EXISTS order_header;
DROP TABLE IF EXISTS item;
DROP TABLE IF EXISTS tempcustomer;
DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS tempvendor;
DROP TABLE IF EXISTS vendor;
DROP TABLE IF EXISTS person;
DROP TABLE IF EXISTS address;
DROP TABLE IF EXISTS country;
DROP TABLE IF EXISTS state;

CREATE TABLE state (state_id VARCHAR(5) PRIMARY KEY,
    latitude REAL,
    longitude REAL,
    name VARCHAR(40)
    );
    
CREATE TABLE country (country_id VARCHAR(5) PRIMARY KEY,
    latitude REAL,
    longitude REAL,
    name VARCHAR(40)
    );
    
CREATE TABLE address (address_id INTEGER PRIMARY KEY,
    street1 VARCHAR(50),
    street2 VARCHAR(50),
    city VARCHAR(50),
    state_id VARCHAR(5),
    postal_code VARCHAR(10),
    country_id VARCHAR(5),
    FOREIGN KEY (state_id) REFERENCES state(state_id),
    FOREIGN KEY (country_id) REFERENCES country(country_id)
    );
    
CREATE TABLE person (person_id integer primary key,
    name VARCHAR(40),
    phone VARCHAR(20),
    email VARCHAR(40)
);

CREATE TABLE tempcustomer (customer_person_id INTEGER PRIMARY KEY,
    bill_address_id INTEGER,
    ship_address_id INTEGER,
    FOREIGN KEY (customer_person_id) REFERENCES person(person_id),
    FOREIGN KEY (bill_address_id) REFERENCES address(address_id),
    FOREIGN KEY (ship_address_id) REFERENCES address(address_id)
);

CREATE TABLE customer (customer_id INTEGER PRIMARY KEY,
    name VARCHAR(40),
    phone VARCHAR(20),
    email VARCHAR(40),
    street1 VARCHAR(50),
    street2 VARCHAR(50),
    city VARCHAR(50),
    state_id VARCHAR(5),
    postal_code VARCHAR(10),
    country_id VARCHAR(5),
    billto_customer_id INTEGER,
    FOREIGN KEY (billto_customer_id) REFERENCES customer(customer_id),
    FOREIGN KEY (state_id) REFERENCES state(state_id),
    FOREIGN KEY (country_id) REFERENCES country(country_id)
);



CREATE TABLE tempvendor (vendor_person_id INTEGER PRIMARY KEY,
    remit_address_id INTEGER,
    contact VARCHAR(50),
    FOREIGN KEY (vendor_person_id) REFERENCES person(person_id),
    FOREIGN KEY (remit_address_id) REFERENCES address(address_id)
);


CREATE TABLE vendor (vendor_id INTEGER PRIMARY KEY,
    name VARCHAR(40),
    phone VARCHAR(20),
    email VARCHAR(40),
    contact VARCHAR(50),
    remit_street1 VARCHAR(50),
    remit_street2 VARCHAR(50),
    remit_city VARCHAR(50),
    remit_state_id VARCHAR(5),
    remit_postal_code VARCHAR(10),
    remit_country_id VARCHAR(5),
    FOREIGN KEY (remit_state_id) REFERENCES state(state_id),
    FOREIGN KEY (remit_country_id) REFERENCES country(country_id)
);



CREATE TABLE item (item_id INTEGER primary key,
    description VARCHAR(40),
    price REAL,
    vendor_id INTEGER,
    FOREIGN KEY (vendor_id) REFERENCES vendor(vendor_id)    
    );

CREATE TABLE order_header (order_id INTEGER primary key,
    customer_id INTEGER,
    order_datetime DATETIME,
    total Real,
    FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
    );

CREATE TABLE order_detail (order_id INTEGER,
    item_id INTEGER,
    quantity INTEGER,
    price Real,    
    PRIMARY KEY (order_id, item_id),
    FOREIGN KEY (order_id) REFERENCES order_header(order_id), 
    FOREIGN KEY (item_id) REFERENCES item(item_id) 
    );

Paste this to insert the data and build the balances.

-- Toy Store Order Sample Database
-- Introduction to Database Systems Modeling and Administration
-- James M. Reneau Ph.D.
-- Version 2025-02-08
-- C) J.M.Reneau Ph.D. - All Rights Reserved

-- Insert Sample Data and Update Script

-- countries from https://developers.google.com/public-data/docs/canonical/countries_csv
-- states from https://developers.google.com/public-data/docs/canonical/states_csv
-- random US addresses https://www.randomlists.com/random-addresses?qty=100
-- Random UK addresses https://www.doogal.co.uk/Randomaddresses

INSERT INTO state VALUES('AK',63.588753,-154.493062,'Alaska');
INSERT INTO state VALUES('AL',32.318231,-86.902298,'Alabama');
INSERT INTO state VALUES('AR',35.20105,-91.831833,'Arkansas');
INSERT INTO state VALUES('AZ',34.048928,-111.093731,'Arizona');
INSERT INTO state VALUES('CA',36.778261,-119.417932,'California');
INSERT INTO state VALUES('CO',39.550051,-105.782067,'Colorado');
INSERT INTO state VALUES('CT',41.603221,-73.087749,'Connecticut');
INSERT INTO state VALUES('DC',38.905985,-77.033418,'District of Columbia');
INSERT INTO state VALUES('DE',38.910832,-75.52767,'Delaware');
INSERT INTO state VALUES('FL',27.664827,-81.515754,'Florida');
INSERT INTO state VALUES('GA',32.157435,-82.907123,'Georgia');
INSERT INTO state VALUES('HI',19.898682,-155.665857,'Hawaii');
INSERT INTO state VALUES('IA',41.878003,-93.097702,'Iowa');
INSERT INTO state VALUES('id',44.068202,-114.742041,'Idaho');
INSERT INTO state VALUES('IL',40.633125,-89.398528,'Illinois');
INSERT INTO state VALUES('IN',40.551217,-85.602364,'Indiana');
INSERT INTO state VALUES('KS',39.011902,-98.484246,'Kansas');
INSERT INTO state VALUES('KY',37.839333,-84.270018,'Kentucky');
INSERT INTO state VALUES('LA',31.244823,-92.145024,'Louisiana');
INSERT INTO state VALUES('MA',42.407211,-71.382437,'Massachusetts');
INSERT INTO state VALUES('MD',39.045755,-76.641271,'Maryland');
INSERT INTO state VALUES('ME',45.253783,-69.445469,'Maine');
INSERT INTO state VALUES('MI',44.314844,-85.602364,'Michigan');
INSERT INTO state VALUES('MN',46.729553,-94.6859,'Minnesota');
INSERT INTO state VALUES('MO',37.964253,-91.831833,'Missouri');
INSERT INTO state VALUES('MS',32.354668,-89.398528,'Mississippi');
INSERT INTO state VALUES('MT',46.879682,-110.362566,'Montana');
INSERT INTO state VALUES('NC',35.759573,-79.0193,'North Carolina');
INSERT INTO state VALUES('ND',47.551493,-101.002012,'North Dakota');
INSERT INTO state VALUES('NE',41.492537,-99.901813,'Nebraska');
INSERT INTO state VALUES('NH',43.193852,-71.572395,'New Hampshire');
INSERT INTO state VALUES('NJ',40.058324,-74.405661,'New Jersey');
INSERT INTO state VALUES('NM',34.97273,-105.032363,'New Mexico');
INSERT INTO state VALUES('NV',38.80261,-116.419389,'Nevada');
INSERT INTO state VALUES('NY',43.299428,-74.217933,'New York');
INSERT INTO state VALUES('OH',40.417287,-82.907123,'Ohio');
INSERT INTO state VALUES('OK',35.007752,-97.092877,'Oklahoma');
INSERT INTO state VALUES('OR',43.804133,-120.554201,'Oregon');
INSERT INTO state VALUES('PA',41.203322,-77.194525,'Pennsylvania');
INSERT INTO state VALUES('PR',18.220833,-66.590149,'Puerto Rico');
INSERT INTO state VALUES('RI',41.580095,-71.477429,'Rhode Island');
INSERT INTO state VALUES('SC',33.836081,-81.163725,'South Carolina');
INSERT INTO state VALUES('SD',43.969515,-99.901813,'South Dakota');
INSERT INTO state VALUES('TN',35.517491,-86.580447,'Tennessee');
INSERT INTO state VALUES('TX',31.968599,-99.901813,'Texas');
INSERT INTO state VALUES('UT',39.32098,-111.093731,'Utah');
INSERT INTO state VALUES('VA',37.431573,-78.656894,'Virginia');
INSERT INTO state VALUES('VT',44.558803,-72.577841,'Vermont');
INSERT INTO state VALUES('WA',47.751074,-120.740139,'Washington');
INSERT INTO state VALUES('WI',43.78444,-88.787868,'Wisconsin');
INSERT INTO state VALUES('WV',38.597626,-80.454903,'West Virginia');
INSERT INTO state VALUES('WY',43.075968,-107.290284,'Wyoming');
    
INSERT INTO country VALUES('AD',42.546245,1.601554,'Andorra');
INSERT INTO country VALUES('AE',23.424076,53.847818,'United Arab Emirates');
INSERT INTO country VALUES('AF',33.93911,67.709953,'Afghanistan');
INSERT INTO country VALUES('AG',17.060816,-61.796428,'Antigua and Barbuda');
INSERT INTO country VALUES('AI',18.220554,-63.068615,'Anguilla');
INSERT INTO country VALUES('AL',41.153332,20.168331,'Albania');
INSERT INTO country VALUES('AM',40.069099,45.038189,'Armenia');
INSERT INTO country VALUES('AN',12.226079,-69.060087,'Netherlands Antilles');
INSERT INTO country VALUES('AO',-11.202692,17.873887,'Angola');
INSERT INTO country VALUES('AQ',-75.250973,-0.071389,'Antarctica');
INSERT INTO country VALUES('AR',-38.416097,-63.616672,'Argentina');
INSERT INTO country VALUES('AS',-14.270972,-170.132217,'American Samoa');
INSERT INTO country VALUES('AT',47.516231,14.550072,'Austria');
INSERT INTO country VALUES('AU',-25.274398,133.775136,'Australia');
INSERT INTO country VALUES('AW',12.52111,-69.968338,'Aruba');
INSERT INTO country VALUES('AZ',40.143105,47.576927,'Azerbaijan');
INSERT INTO country VALUES('BA',43.915886,17.679076,'Bosnia and Herzegovina');
INSERT INTO country VALUES('BB',13.193887,-59.543198,'Barbados');
INSERT INTO country VALUES('BD',23.684994,90.356331,'Bangladesh');
INSERT INTO country VALUES('BE',50.503887,4.469936,'Belgium');
INSERT INTO country VALUES('BF',12.238333,-1.561593,'Burkina Faso');
INSERT INTO country VALUES('BG',42.733883,25.48583,'Bulgaria');
INSERT INTO country VALUES('BH',25.930414,50.637772,'Bahrain');
INSERT INTO country VALUES('BI',-3.373056,29.918886,'Burundi');
INSERT INTO country VALUES('BJ',9.30769,2.315834,'Benin');
INSERT INTO country VALUES('BM',32.321384,-64.75737,'Bermuda');
INSERT INTO country VALUES('BN',4.535277,114.727669,'Brunei');
INSERT INTO country VALUES('BO',-16.290154,-63.588653,'Bolivia');
INSERT INTO country VALUES('BR',-14.235004,-51.92528,'Brazil');
INSERT INTO country VALUES('BS',25.03428,-77.39628,'Bahamas');
INSERT INTO country VALUES('BT',27.514162,90.433601,'Bhutan');
INSERT INTO country VALUES('BV',-54.423199,3.413194,'Bouvet Island');
INSERT INTO country VALUES('BW',-22.328474,24.684866,'Botswana');
INSERT INTO country VALUES('BY',53.709807,27.953389,'Belarus');
INSERT INTO country VALUES('BZ',17.189877,-88.49765,'Belize');
INSERT INTO country VALUES('CA',56.130366,-106.346771,'Canada');
INSERT INTO country VALUES('CC',-12.164165,96.870956,'Cocos [Keeling] Islands');
INSERT INTO country VALUES('CD',-4.038333,21.758664,'Congo [DRC]');
INSERT INTO country VALUES('CF',6.611111,20.939444,'Central African Republic');
INSERT INTO country VALUES('CG',-0.228021,15.827659,'Congo [Republic]');
INSERT INTO country VALUES('CH',46.818188,8.227512,'Switzerland');
INSERT INTO country VALUES('CI',7.539989,-5.54708,'Côte d''Ivoire');
INSERT INTO country VALUES('CK',-21.236736,-159.777671,'Cook Islands');
INSERT INTO country VALUES('CL',-35.675147,-71.542969,'Chile');
INSERT INTO country VALUES('CM',7.369722,12.354722,'Cameroon');
INSERT INTO country VALUES('CN',35.86166,104.195397,'China');
INSERT INTO country VALUES('CO',4.570868,-74.297333,'Colombia');
INSERT INTO country VALUES('CR',9.748917,-83.753428,'Costa Rica');
INSERT INTO country VALUES('CU',21.521757,-77.781167,'Cuba');
INSERT INTO country VALUES('CV',16.002082,-24.013197,'Cape Verde');
INSERT INTO country VALUES('CX',-10.447525,105.690449,'Christmas Island');
INSERT INTO country VALUES('CY',35.126413,33.429859,'Cyprus');
INSERT INTO country VALUES('CZ',49.817492,15.472962,'Czech Republic');
INSERT INTO country VALUES('DE',51.165691,10.451526,'Germany');
INSERT INTO country VALUES('DJ',11.825138,42.590275,'Djibouti');
INSERT INTO country VALUES('DK',56.26392,9.501785,'Denmark');
INSERT INTO country VALUES('DM',15.414999,-61.370976,'Dominica');
INSERT INTO country VALUES('DO',18.735693,-70.162651,'Dominican Republic');
INSERT INTO country VALUES('DZ',28.033886,1.659626,'Algeria');
INSERT INTO country VALUES('EC',-1.831239,-78.183406,'Ecuador');
INSERT INTO country VALUES('EE',58.595272,25.013607,'Estonia');
INSERT INTO country VALUES('EG',26.820553,30.802498,'Egypt');
INSERT INTO country VALUES('EH',24.215527,-12.885834,'Western Sahara');
INSERT INTO country VALUES('ER',15.179384,39.782334,'Eritrea');
INSERT INTO country VALUES('ES',40.463667,-3.74922,'Spain');
INSERT INTO country VALUES('ET',9.145,40.489673,'Ethiopia');
INSERT INTO country VALUES('FI',61.92411,25.748151,'Finland');
INSERT INTO country VALUES('FJ',-16.578193,179.414413,'Fiji');
INSERT INTO country VALUES('FK',-51.796253,-59.523613,'Falkland Islands [Islas Malvinas]');
INSERT INTO country VALUES('FM',7.425554,150.550812,'Micronesia');
INSERT INTO country VALUES('FO',61.892635,-6.911806,'Faroe Islands');
INSERT INTO country VALUES('FR',46.227638,2.213749,'France');
INSERT INTO country VALUES('GA',-0.803689,11.609444,'Gabon');
INSERT INTO country VALUES('GB',55.378051,-3.435973,'United Kingdom');
INSERT INTO country VALUES('GD',12.262776,-61.604171,'Grenada');
INSERT INTO country VALUES('GE',42.315407,43.356892,'Georgia');
INSERT INTO country VALUES('GF',3.933889,-53.125782,'French Guiana');
INSERT INTO country VALUES('GG',49.465691,-2.585278,'Guernsey');
INSERT INTO country VALUES('GH',7.946527,-1.023194,'Ghana');
INSERT INTO country VALUES('GI',36.137741,-5.345374,'Gibraltar');
INSERT INTO country VALUES('GL',71.706936,-42.604303,'Greenland');
INSERT INTO country VALUES('GM',13.443182,-15.310139,'Gambia');
INSERT INTO country VALUES('GN',9.945587,-9.696645,'Guinea');
INSERT INTO country VALUES('GP',16.995971,-62.067641,'Guadeloupe');
INSERT INTO country VALUES('GQ',1.650801,10.267895,'Equatorial Guinea');
INSERT INTO country VALUES('GR',39.074208,21.824312,'Greece');
INSERT INTO country VALUES('GS',-54.429579,-36.587909,'South Georgia and the South Sandwich Islands');
INSERT INTO country VALUES('GT',15.783471,-90.230759,'Guatemala');
INSERT INTO country VALUES('GU',13.444304,144.793731,'Guam');
INSERT INTO country VALUES('GW',11.803749,-15.180413,'Guinea-Bissau');
INSERT INTO country VALUES('GY',4.860416,-58.93018,'Guyana');
INSERT INTO country VALUES('GZ',31.354676,34.308825,'Gaza Strip');
INSERT INTO country VALUES('HK',22.396428,114.109497,'Hong Kong');
INSERT INTO country VALUES('HM',-53.08181,73.504158,'Heard Island and McDonald Islands');
INSERT INTO country VALUES('HN',15.199999,-86.241905,'Honduras');
INSERT INTO country VALUES('HR',45.1,15.2,'Croatia');
INSERT INTO country VALUES('HT',18.971187,-72.285215,'Haiti');
INSERT INTO country VALUES('HU',47.162494,19.503304,'Hungary');
INSERT INTO country VALUES('id',-0.789275,113.921327,'Indonesia');
INSERT INTO country VALUES('IE',53.41291,-8.24389,'Ireland');
INSERT INTO country VALUES('IL',31.046051,34.851612,'Israel');
INSERT INTO country VALUES('IM',54.236107,-4.548056,'Isle of Man');
INSERT INTO country VALUES('IN',20.593684,78.96288,'India');
INSERT INTO country VALUES('IO',-6.343194,71.876519,'British Indian Ocean Territory');
INSERT INTO country VALUES('IQ',33.223191,43.679291,'Iraq');
INSERT INTO country VALUES('IR',32.427908,53.688046,'Iran');
INSERT INTO country VALUES('IS',64.963051,-19.020835,'Iceland');
INSERT INTO country VALUES('IT',41.87194,12.56738,'Italy');
INSERT INTO country VALUES('JE',49.214439,-2.13125,'Jersey');
INSERT INTO country VALUES('JM',18.109581,-77.297508,'Jamaica');
INSERT INTO country VALUES('JO',30.585164,36.238414,'Jordan');
INSERT INTO country VALUES('JP',36.204824,138.252924,'Japan');
INSERT INTO country VALUES('KE',-0.023559,37.906193,'Kenya');
INSERT INTO country VALUES('KG',41.20438,74.766098,'Kyrgyzstan');
INSERT INTO country VALUES('KH',12.565679,104.990963,'Cambodia');
INSERT INTO country VALUES('KI',-3.370417,-168.734039,'Kiribati');
INSERT INTO country VALUES('KM',-11.875001,43.872219,'Comoros');
INSERT INTO country VALUES('KN',17.357822,-62.782998,'Saint Kitts and Nevis');
INSERT INTO country VALUES('KP',40.339852,127.510093,'North Korea');
INSERT INTO country VALUES('KR',35.907757,127.766922,'South Korea');
INSERT INTO country VALUES('KW',29.31166,47.481766,'Kuwait');
INSERT INTO country VALUES('KY',19.513469,-80.566956,'Cayman Islands');
INSERT INTO country VALUES('KZ',48.019573,66.923684,'Kazakhstan');
INSERT INTO country VALUES('LA',19.85627,102.495496,'Laos');
INSERT INTO country VALUES('LB',33.854721,35.862285,'Lebanon');
INSERT INTO country VALUES('LC',13.909444,-60.978893,'Saint Lucia');
INSERT INTO country VALUES('LI',47.166,9.555373,'Liechtenstein');
INSERT INTO country VALUES('LK',7.873054,80.771797,'Sri Lanka');
INSERT INTO country VALUES('LR',6.428055,-9.429499,'Liberia');
INSERT INTO country VALUES('LS',-29.609988,28.233608,'Lesotho');
INSERT INTO country VALUES('LT',55.169438,23.881275,'Lithuania');
INSERT INTO country VALUES('LU',49.815273,6.129583,'Luxembourg');
INSERT INTO country VALUES('LV',56.879635,24.603189,'Latvia');
INSERT INTO country VALUES('LY',26.3351,17.228331,'Libya');
INSERT INTO country VALUES('MA',31.791702,-7.09262,'Morocco');
INSERT INTO country VALUES('MC',43.750298,7.412841,'Monaco');
INSERT INTO country VALUES('MD',47.411631,28.369885,'Moldova');
INSERT INTO country VALUES('ME',42.708678,19.37439,'Montenegro');
INSERT INTO country VALUES('MG',-18.766947,46.869107,'Madagascar');
INSERT INTO country VALUES('MH',7.131474,171.184478,'Marshall Islands');
INSERT INTO country VALUES('MK',41.608635,21.745275,'Macedonia [FYROM]');
INSERT INTO country VALUES('ML',17.570692,-3.996166,'Mali');
INSERT INTO country VALUES('MM',21.913965,95.956223,'Myanmar [Burma]');
INSERT INTO country VALUES('MN',46.862496,103.846656,'Mongolia');
INSERT INTO country VALUES('MO',22.198745,113.543873,'Macau');
INSERT INTO country VALUES('MP',17.33083,145.38469,'Northern Mariana Islands');
INSERT INTO country VALUES('MQ',14.641528,-61.024174,'Martinique');
INSERT INTO country VALUES('MR',21.00789,-10.940835,'Mauritania');
INSERT INTO country VALUES('MS',16.742498,-62.187366,'Montserrat');
INSERT INTO country VALUES('MT',35.937496,14.375416,'Malta');
INSERT INTO country VALUES('MU',-20.348404,57.552152,'Mauritius');
INSERT INTO country VALUES('MV',3.202778,73.22068,'Maldives');
INSERT INTO country VALUES('MW',-13.254308,34.301525,'Malawi');
INSERT INTO country VALUES('MX',23.634501,-102.552784,'Mexico');
INSERT INTO country VALUES('MY',4.210484,101.975766,'Malaysia');
INSERT INTO country VALUES('MZ',-18.665695,35.529562,'Mozambique');
INSERT INTO country VALUES('NA',-22.95764,18.49041,'Namibia');
INSERT INTO country VALUES('NC',-20.904305,165.618042,'New Caledonia');
INSERT INTO country VALUES('NE',17.607789,8.081666,'Niger');
INSERT INTO country VALUES('NF',-29.040835,167.954712,'Norfolk Island');
INSERT INTO country VALUES('NG',9.081999,8.675277,'Nigeria');
INSERT INTO country VALUES('NI',12.865416,-85.207229,'Nicaragua');
INSERT INTO country VALUES('NL',52.132633,5.291266,'Netherlands');
INSERT INTO country VALUES('NO',60.472024,8.468946,'Norway');
INSERT INTO country VALUES('NP',28.394857,84.124008,'Nepal');
INSERT INTO country VALUES('NR',-0.522778,166.931503,'Nauru');
INSERT INTO country VALUES('NU',-19.054445,-169.867233,'Niue');
INSERT INTO country VALUES('NZ',-40.900557,174.885971,'New Zealand');
INSERT INTO country VALUES('OM',21.512583,55.923255,'Oman');
INSERT INTO country VALUES('PA',8.537981,-80.782127,'Panama');
INSERT INTO country VALUES('PE',-9.189967,-75.015152,'Peru');
INSERT INTO country VALUES('PF',-17.679742,-149.406843,'French Polynesia');
INSERT INTO country VALUES('PG',-6.314993,143.95555,'Papua New Guinea');
INSERT INTO country VALUES('PH',12.879721,121.774017,'Philippines');
INSERT INTO country VALUES('PK',30.375321,69.345116,'Pakistan');
INSERT INTO country VALUES('PL',51.919438,19.145136,'Poland');
INSERT INTO country VALUES('PM',46.941936,-56.27111,'Saint Pierre and Miquelon');
INSERT INTO country VALUES('PN',-24.703615,-127.439308,'Pitcairn Islands');
INSERT INTO country VALUES('PR',18.220833,-66.590149,'Puerto Rico');
INSERT INTO country VALUES('PS',31.952162,35.233154,'Palestinian Territories');
INSERT INTO country VALUES('PT',39.399872,-8.224454,'Portugal');
INSERT INTO country VALUES('PW',7.51498,134.58252,'Palau');
INSERT INTO country VALUES('PY',-23.442503,-58.443832,'Paraguay');
INSERT INTO country VALUES('QA',25.354826,51.183884,'Qatar');
INSERT INTO country VALUES('RE',-21.115141,55.536384,'Réunion');
INSERT INTO country VALUES('RO',45.943161,24.96676,'Romania');
INSERT INTO country VALUES('RS',44.016521,21.005859,'Serbia');
INSERT INTO country VALUES('RU',61.52401,105.318756,'Russia');
INSERT INTO country VALUES('RW',-1.940278,29.873888,'Rwanda');
INSERT INTO country VALUES('SA',23.885942,45.079162,'Saudi Arabia');
INSERT INTO country VALUES('SB',-9.64571,160.156194,'Solomon Islands');
INSERT INTO country VALUES('SC',-4.679574,55.491977,'Seychelles');
INSERT INTO country VALUES('SD',12.862807,30.217636,'Sudan');
INSERT INTO country VALUES('SE',60.128161,18.643501,'Sweden');
INSERT INTO country VALUES('SG',1.352083,103.819836,'Singapore');
INSERT INTO country VALUES('SH',-24.143474,-10.030696,'Saint Helena');
INSERT INTO country VALUES('SI',46.151241,14.995463,'Slovenia');
INSERT INTO country VALUES('SJ',77.553604,23.670272,'Svalbard and Jan Mayen');
INSERT INTO country VALUES('SK',48.669026,19.699024,'Slovakia');
INSERT INTO country VALUES('SL',8.460555,-11.779889,'Sierra Leone');
INSERT INTO country VALUES('SM',43.94236,12.457777,'San Marino');
INSERT INTO country VALUES('SN',14.497401,-14.452362,'Senegal');
INSERT INTO country VALUES('SO',5.152149,46.199616,'Somalia');
INSERT INTO country VALUES('SR',3.919305,-56.027783,'Suriname');
INSERT INTO country VALUES('ST',0.18636,6.613081,'São Tomé and Príncipe');
INSERT INTO country VALUES('SV',13.794185,-88.89653,'El Salvador');
INSERT INTO country VALUES('SY',34.802075,38.996815,'Syria');
INSERT INTO country VALUES('SZ',-26.522503,31.465866,'Swaziland');
INSERT INTO country VALUES('TC',21.694025,-71.797928,'Turks and Caicos Islands');
INSERT INTO country VALUES('TD',15.454166,18.732207,'Chad');
INSERT INTO country VALUES('TF',-49.280366,69.348557,'French Southern Territories');
INSERT INTO country VALUES('TG',8.619543,0.824782,'Togo');
INSERT INTO country VALUES('TH',15.870032,100.992541,'Thailand');
INSERT INTO country VALUES('TJ',38.861034,71.276093,'Tajikistan');
INSERT INTO country VALUES('TK',-8.967363,-171.855881,'Tokelau');
INSERT INTO country VALUES('TL',-8.874217,125.727539,'Timor-Leste');
INSERT INTO country VALUES('TM',38.969719,59.556278,'Turkmenistan');
INSERT INTO country VALUES('TN',33.886917,9.537499,'Tunisia');
INSERT INTO country VALUES('TO',-21.178986,-175.198242,'Tonga');
INSERT INTO country VALUES('TR',38.963745,35.243322,'Turkey');
INSERT INTO country VALUES('TT',10.691803,-61.222503,'Trinidad and Tobago');
INSERT INTO country VALUES('TV',-7.109535,177.64933,'Tuvalu');
INSERT INTO country VALUES('TW',23.69781,120.960515,'Taiwan');
INSERT INTO country VALUES('TZ',-6.369028,34.888822,'Tanzania');
INSERT INTO country VALUES('UA',48.379433,31.16558,'Ukraine');
INSERT INTO country VALUES('UG',1.373333,32.290275,'Uganda');
INSERT INTO country VALUES('UM',NULL,NULL,'U.S. Minor Outlying Islands');
INSERT INTO country VALUES('US',37.09024,-95.712891,'United States');
INSERT INTO country VALUES('UY',-32.522779,-55.765835,'Uruguay');
INSERT INTO country VALUES('UZ',41.377491,64.585262,'Uzbekistan');
INSERT INTO country VALUES('VA',41.902916,12.453389,'Vatican City');
INSERT INTO country VALUES('VC',12.984305,-61.287228,'Saint Vincent and the Grenadines');
INSERT INTO country VALUES('VE',6.42375,-66.58973,'Venezuela');
INSERT INTO country VALUES('VG',18.420695,-64.639968,'British Virgin Islands');
INSERT INTO country VALUES('VI',18.335765,-64.896335,'U.S. Virgin Islands');
INSERT INTO country VALUES('VN',14.058324,108.277199,'Vietnam');
INSERT INTO country VALUES('VU',-15.376706,166.959158,'Vanuatu');
INSERT INTO country VALUES('WF',-13.768752,-177.156097,'Wallis and Futuna');
INSERT INTO country VALUES('WS',-13.759029,-172.104629,'Samoa');
INSERT INTO country VALUES('XK',42.602636,20.902977,'Kosovo');
INSERT INTO country VALUES('YE',15.552727,48.516388,'Yemen');
INSERT INTO country VALUES('YT',-12.8275,45.166244,'Mayotte');
INSERT INTO country VALUES('ZA',-30.559482,22.937506,'South Africa');
INSERT INTO country VALUES('ZM',-13.133897,27.849332,'Zambia');
INSERT INTO country VALUES('ZW',-19.015438,29.154857,'Zimbabwe');
    
INSERT INTO address VALUES (1,'P.O. Box 60999',NULL,'Mundelein','IL','60060','US');
INSERT INTO address VALUES (2,'8066 Boston Ave.',NULL,'Mundelein','IL','60060','US');
INSERT INTO address VALUES (3,'P.O. Box 55443',NULL,'Muskego','WI','53150','US');
INSERT INTO address VALUES (4,'9787 East Arrowhead Avenue',NULL,'Muskego','WI','53150','US');
INSERT INTO address VALUES (5,'8359 Hall Ave.',NULL,'Highland','IN','46322','US');
INSERT INTO address VALUES (6,'P.O. Box 67',NULL,'Highland','IN','46322','US');
INSERT INTO address VALUES (7,'330 Marvon Drive',NULL,'Michigan City','IN','46360','US');
INSERT INTO address VALUES (8,'339 Shadow Brook Rd.',NULL,'Long Branch','NJ','07740','US');
INSERT INTO address VALUES (9,'9528 Stonybrook Street',NULL,'Fuquay Varina','NC','27526','US');
INSERT INTO address VALUES (10,'8557 Grove Street',NULL,'Harrison Township','MI','48045','US');
INSERT INTO address VALUES (11,'165 North Beechwood Dr.',NULL,'Dickson','TN','37055','US');
INSERT INTO address VALUES (12,'7 Livingston St.',NULL,'Flatwoods','NY','13023','US');
INSERT INTO address VALUES (13,'5 Rock Maple Ave.',NULL,'Chesterton','IN','46304','US');
INSERT INTO address VALUES (14,'147 Laurel Ave.',NULL,'Sugar Land','TX','77478','US');
INSERT INTO address VALUES (15,'217 Peninsula Avenue',NULL,'Syosset','NY','11791','US');
INSERT INTO address VALUES (16,'2 Old Fairway Street','Apt 23','Millville','NJ','08332','US');
INSERT INTO address VALUES (17,'22 Pine Lane',NULL,'East Haven','CT','06512','US');
INSERT INTO address VALUES (18,'882 Orange Street',NULL,'Flatwoods','NY','13023','US');
INSERT INTO address VALUES (19,'39 Jackson Lane',NULL,'Asheboro','NC','27205','US');
INSERT INTO address VALUES (20,'7663 Arcadia Court',NULL,'Marietta','GA','30008','US');
INSERT INTO address VALUES (21,'139 Piper Street',NULL,'Canandaigua','NY','14424','US');
INSERT INTO address VALUES (22,'9630 Harvey Rd.',NULL,'Victoria','TX','77904','US');
INSERT INTO address VALUES (23,'411 New Saddle Ave.',NULL,'Flatwoods','IN','47411','US');
INSERT INTO address VALUES (24,'7952 Arrowhead Street',NULL,'Midlothian','VA','23112','US');
INSERT INTO address VALUES (25,'8184 Lafayette Street',NULL,'Fishers','IN','46037','US');
INSERT INTO address VALUES (26,'6 Pheasant Ave.',NULL,'Summerville','SC','29483','US');
INSERT INTO address VALUES (27,'841 Plumb Branch Lane',NULL,'Gastonia','NC','28052','US');
INSERT INTO address VALUES (28,'637 NW. Harrison Road',NULL,'Mount Laurel','NJ','08054','US');
INSERT INTO address VALUES (29,'39 Elizabeth Street',NULL,'Baton Rouge','LA','70806','US');
INSERT INTO address VALUES (30,'450 Newbridge Street',NULL,'Chicago Heights','IL','60411','US');
INSERT INTO address VALUES (31,'7901 Jones Ave.',NULL,'North Brunswick','NJ','08902','US');
INSERT INTO address VALUES (32,'374 South Brook Drive',NULL,'Halethorpe','MD','21227','US');
INSERT INTO address VALUES (33,'310 Nicolls St.',NULL,'Harlingen','TX','78552','US');
INSERT INTO address VALUES (34,'7 N. Tanglewood Dr.',NULL,'Torrance','CA','90505','US');
INSERT INTO address VALUES (35,'148 Anderson Ave.',NULL,'Flatwoods','KY','41144','US');
INSERT INTO address VALUES (36,'196 Del Monte Drive',NULL,'Chillicothe','OH','45601','US');
INSERT INTO address VALUES (37,'304 Stillwater Dr.',NULL,'Pawtucket','RI','02860','US');
INSERT INTO address VALUES (38,'508 Rose St.',NULL,'Elizabeth City','NC','27909','US');
INSERT INTO address VALUES (39,'335 Windfall Street',NULL,'Savage','MN','55378','US');
INSERT INTO address VALUES (40,'74 North Lane',NULL,'Bensalem','PA','19020','US');
INSERT INTO address VALUES (41,'7583 Goldfield Court','Second Floor','Glenside','PA','19038','US');
INSERT INTO address VALUES (42,'9944 S. Jackson St.',NULL,'Elizabethton','TN','37643','US');
INSERT INTO address VALUES (43,'8065 Madison Lane',NULL,'Barberton','OH','44203','US');
INSERT INTO address VALUES (44,'7961 Greenrose St.',NULL,'Severn','MD','21144','US');
INSERT INTO address VALUES (45,'313 Boston Lane',NULL,'Snohomish','WA','98290','US');
INSERT INTO address VALUES (46,'30 South Applegate Ave.',NULL,'Dalton','GA','30721','US');
INSERT INTO address VALUES (47,'651 Lafayette Dr.',NULL,'Iowa City','IA','52240','US');
INSERT INTO address VALUES (48,'92 Overlook Street',NULL,'Point Pleasant','NJ','08742','US');
INSERT INTO address VALUES (49,'7312 53rd Dr.',NULL,'Hyattsville','MD','20782','US');
INSERT INTO address VALUES (50,'7133 Greenview St.',NULL,'Cantonment','FL','32533','US');
INSERT INTO address VALUES (51,'77 N. Glenholme St.',NULL,'Quakertown','PA','18951','US');
INSERT INTO address VALUES (52,'47 Purple Finch Street',NULL,'West Warwick','RI','02893','US');
INSERT INTO address VALUES (53,'9516 Academy Ave.',NULL,'Morton Grove','IL','60053','US');
INSERT INTO address VALUES (54,'44 Pheasant Court',NULL,'Sun City','AZ','85351','US');
INSERT INTO address VALUES (55,'8995 Pin Oak Drive',NULL,'Glendale','AZ','85302','US');
INSERT INTO address VALUES (56,'29 Wentworth Ave.',NULL,'Fresh Meadows','NY','11365','US');
INSERT INTO address VALUES (57,'451 Ann St.',NULL,'Trussville','AL','35173','US');
INSERT INTO address VALUES (58,'58 Walnutwood St.',NULL,'Kaukauna','WI','54130','US');
INSERT INTO address VALUES (59,'164 Purple Finch Lane',NULL,'Point Pleasant','WV','25998','US');
INSERT INTO address VALUES (60,'239 Linden St.',NULL,'Lanham','MD','20706','US');
INSERT INTO address VALUES (61,'66 Miller St.','APT 6B','Medina','OH','44256','US');
INSERT INTO address VALUES (62,'706 2nd St.',NULL,'Elizabethtown','PA','17022','US');
INSERT INTO address VALUES (63,'117 Honey Creek Dr.',NULL,'Tualatin','OR','97062','US');
INSERT INTO address VALUES (64,'777 Fulton St.',NULL,'Westmont','IL','60559','US');
INSERT INTO address VALUES (65,'77 Pin Oak St.',NULL,'Wadsworth','OH','44281','US');
INSERT INTO address VALUES (66,'11 Newcastle Lane',NULL,'Kissimmee','FL','34741','US');
INSERT INTO address VALUES (67,'860 Foster Street',NULL,'Champlin','MN','55316','US');
INSERT INTO address VALUES (68,'315 Snake Hill Ave',NULL,'Sioux Falls','SD','57103','US');
INSERT INTO address VALUES (69,'869 William Court',NULL,'Point Pleasant','WV','25998','US');
INSERT INTO address VALUES (70,'8138 Richardson Lane',NULL,'Monroe Township','NJ','08831','US');
INSERT INTO address VALUES (71,'940 Lincoln Street',NULL,'Neptune','NJ','07753','US');
INSERT INTO address VALUES (72,'8 West Fulton St.',NULL,'Windsor Mill','MD','21244','US');
INSERT INTO address VALUES (73,'8220 Belmont Street',NULL,'Mechanicsville','VA','23111','US');
INSERT INTO address VALUES (74,'22 Tailwater Ave.',NULL,'La Porte','IN','46350','US');
INSERT INTO address VALUES (75,'9084 Central Road',NULL,'Feasterville Trevose','PA','19053','US');
INSERT INTO address VALUES (76,'760 George Drive',NULL,'Lakewood','NJ','08701','US');
INSERT INTO address VALUES (77,'279 North 10th Ave.',NULL,'Springfield Gardens','NY','11413','US');
INSERT INTO address VALUES (78,'4 St Margarets Lane',NULL,'Downers Grove','IL','60515','US');
INSERT INTO address VALUES (79,'7921 Princeton Lane',NULL,'Allison Park','PA','15101','US');
INSERT INTO address VALUES (80,'8 Monroe Dr.',NULL,'Lawrence Township','NJ','08648','US');
INSERT INTO address VALUES (81,'87 NE. Pennsylvania Lane',NULL,'Goshen','IN','46526','US');
INSERT INTO address VALUES (82,'32 Deerfield Lane',NULL,'Ontario','CA','91762','US');
INSERT INTO address VALUES (83,'8633 Rockledge Drive',NULL,'Pleasanton','CA','94566','US');
INSERT INTO address VALUES (85,'14 Virginia Street',NULL,'Yuma','AZ','85365','US');
INSERT INTO address VALUES (84,'P.O. Box 7654',NULL,'Yuma','AZ','85365','US');
INSERT INTO address VALUES (86,'21 Marlborough Ave.',NULL,'Cuyahoga Falls','OH','44221','US');
INSERT INTO address VALUES (87,'69 West Marsh Ave.',NULL,'South Ozone Park','NY','11420','US');
INSERT INTO address VALUES (89,'9136 Lower River St.',NULL,'Hermitage','TN','37076','US');
INSERT INTO address VALUES (88,'P.O. Box 777',NULL,'Hermitage','TN','37076','US');
INSERT INTO address VALUES (90,'9 Border Drive',NULL,'Wooster','OH','44691','US');
INSERT INTO address VALUES (91,'583 Pleasant Lane',NULL,'Jeffersonville','IN','47130','US');
INSERT INTO address VALUES (92,'826 East Corona Avenue',NULL,'Jamaica','NY','11432','US');
INSERT INTO address VALUES (93,'945 Sugar Street',NULL,'Wyoming','MI','49509','US');
INSERT INTO address VALUES (94,'8675 Glenwood St.',NULL,'Prior Lake','MN','55372','US');
INSERT INTO address VALUES (95,'223 Nut Swamp St.',NULL,'Portsmouth','VA','23703','US');
INSERT INTO address VALUES (96,'450 St Paul Ave.',NULL,'Anoka','MN','55303','US');
INSERT INTO address VALUES (97,'9532 S. Second Dr.',NULL,'Wellington','FL','33414','US');
INSERT INTO address VALUES (98,'97 E. Blue Spring Street',NULL,'Florence','SC','29501','US');
INSERT INTO address VALUES (99,'87 E. Queen Lane',NULL,'Newark','NJ','07103','US');
INSERT INTO address VALUES (100,'57 Lincoln St.',NULL,'Decatur','GA','30030','US');
INSERT INTO address VALUES (101,'215 South Bear Hill Avenue',NULL,'Garland','TX','75043','US');
INSERT INTO address VALUES (102,'8224 Cooper Dr.','Apt H','Farmingdale','NY','11735','US');
INSERT INTO address VALUES (103,'9004 Lilac Court',NULL,'Massapequa','NY','11758','US');
INSERT INTO address VALUES (104,'9348 Brickyard St.',NULL,'Catonsville','MD','21228','US');
INSERT INTO address VALUES (105,'408 Berkshire St.',NULL,'Manassas','VA','20109','US');
INSERT INTO address VALUES (106,'2 Ferndale',' Parka Road','Fraddon',NULL,'TR9 6JY','GB');
INSERT INTO address VALUES (107,'8 Duddon Close',NULL,'Prenton',NULL,'CH43 2GL','GB');
INSERT INTO address VALUES (108,'39 Keswick Road',NULL,'Bournemouth',NULL,'BH5 1LR','GB');
INSERT INTO address VALUES (109,'2 Grove Terrace',NULL,'Crediton',NULL,'EX17 3AR','GB');
INSERT INTO address VALUES (110,'92 The Whithys',NULL,'Street',NULL,'BA16 9PL','GB');
INSERT INTO address VALUES (111,'5 Popham Close',NULL,'Bracknell',NULL,'RG12 0XZ','GB');
INSERT INTO address VALUES (112,'Parkwood',NULL,'Milton Abbas',NULL,'DT11 0AZ','GB');
INSERT INTO address VALUES (113,'Friars Corner',' The Street','Dickleburgh',NULL,'IP21 4NQ','GB');
INSERT INTO address VALUES (114,'14 Morland Road',NULL,'Ipswich',NULL,'IP3 0LG','GB');
INSERT INTO address VALUES (115,'207 New Line',NULL,'Bradford',NULL,'BD10 0BN','GB');
INSERT INTO address VALUES (116,'1000 Bellefonte St',NULL,'Russell','KY','41169','US');

INSERT INTO person VALUES (1,'ABC Supply', '1-444-555-6666', '[email protected]');
INSERT INTO tempvendor VALUES (1, 115, 'Bobby');
INSERT INTO person VALUES (2,'Fun Wholesale', '1-922-555-1234', '[email protected]');
INSERT INTO tempvendor VALUES (2, 106, 'Charles');
INSERT INTO person VALUES (3,'XYZ Games and Stuff', '1-555-555-5550', '[email protected]');
INSERT INTO tempvendor VALUES (3, 99, 'Jamye');
INSERT INTO person VALUES (4,'Comet and Asteroid Supply', '1-555-555-1000', '[email protected]');
INSERT INTO tempvendor VALUES (4, 116, 'Bill');

insert into vendor
SELECT vendor_person_id, name, phone, email, contact,
B.street1, B.street2, B.city, B.state_id, B.postal_code, B.country_id
from tempvendor
join person on person.person_id = tempvendor.vendor_person_id
join address AS B on B.address_id = tempvendor.remit_address_id;


INSERT INTO item VALUES (1001,'Blue Flying Disk',7.89,1);
INSERT INTO item VALUES (1002,'Red Flying Disk',7.89,1);
INSERT INTO item VALUES (1003,'Rainbow Flying Disk',8.98,1);
INSERT INTO item VALUES (1004,'Grey Pro Flying Disk',15.98,1);
INSERT INTO item VALUES (1010,'Yellow Butterfly Yo-Yo',4.67,2);
INSERT INTO item VALUES (1011,'Blue Royal Yo-Yo',3.67,2);
INSERT INTO item VALUES (1012,'Giant Wooden Yo-Yo',13.67,2);
INSERT INTO item VALUES (1018,'Pack of Yo-Yo Strings',3.33,2);
INSERT INTO item VALUES (1019,'Yo-Yo Wax',6.67,2);
INSERT INTO item VALUES (1020,'Cards Against Data',18.78,3);
INSERT INTO item VALUES (1022,'Game of Life Improvement',34.78,3);
INSERT INTO item VALUES (1023,'Never Ending Bord Game',26.98,3);
INSERT INTO item VALUES (1024,'Clueless Risk',43.98,3);

INSERT INTO person VALUES (10,'Mega Big Box Accounts Payable','1-959-555-4506','[email protected]');
INSERT INTO tempcustomer VALUES (10,32,32);
INSERT INTO person VALUES (11,'Elizabeth Gonzales','1-954-555-1679','[email protected]');
INSERT INTO tempcustomer VALUES (11,87,87);
INSERT INTO person VALUES (12,'Toys-r-cool Accounts Payable','1-804-555-6912','[email protected]');
INSERT INTO tempcustomer VALUES (12,5,5);
INSERT INTO person VALUES (13,'Kenneth Johnson','1-423-555-3811','[email protected]');
INSERT INTO tempcustomer VALUES (13,65,65);
INSERT INTO person VALUES (14,'Debra Lloyd','1-403-555-8928','[email protected]');
INSERT INTO tempcustomer VALUES (14,54,54);
INSERT INTO person VALUES (15,'Adam Lewis','1-803-555-4557','[email protected]');
INSERT INTO tempcustomer VALUES (15,104,104);
INSERT INTO person VALUES (16,'Jessica Morris','1-914-555-6924','[email protected]');
INSERT INTO tempcustomer VALUES (16,44,44);
INSERT INTO person VALUES (17,'Tiffany Branch','1-420-555-5514','[email protected]');
INSERT INTO tempcustomer VALUES (17,14,14);
INSERT INTO person VALUES (18,'Mega Big Box Store 101','1-299-555-5881','[email protected]');
INSERT INTO tempcustomer VALUES (18,109,109);
INSERT INTO person VALUES (19,'Aaron Blevins','1-470-555-0711','[email protected]');
INSERT INTO tempcustomer VALUES (19,94,94);
INSERT INTO person VALUES (20,'Daniel Williams','1-327-555-6201','[email protected]');
INSERT INTO tempcustomer VALUES (20,11,11);
INSERT INTO person VALUES (21,'Jeffrey Hickman','1-570-555-9459','[email protected]');
INSERT INTO tempcustomer VALUES (21,25,25);
INSERT INTO person VALUES (22,'Michael Cooper','1-877-555-3733','[email protected]');
INSERT INTO tempcustomer VALUES (22,99,99);
INSERT INTO person VALUES (23,'Brenda Pugh','1-438-555-1654','[email protected]');
INSERT INTO tempcustomer VALUES (23,49,49);
INSERT INTO person VALUES (24,'Michael Cuevas','1-850-555-5977','[email protected]');
INSERT INTO tempcustomer VALUES (24,21,21);
INSERT INTO person VALUES (25,'Kiara Jackson','1-414-555-4374','[email protected]');
INSERT INTO tempcustomer VALUES (25,90,90);
INSERT INTO person VALUES (26,'Kathleen Wiggins','1-850-555-2803','[email protected]');
INSERT INTO tempcustomer VALUES (26,69,69);
INSERT INTO person VALUES (27,'Gina Lee','1-673-555-6216','[email protected]');
INSERT INTO tempcustomer VALUES (27,35,35);
INSERT INTO person VALUES (28,'Regina Hayes','1-986-555-0916','[email protected]');
INSERT INTO tempcustomer VALUES (28,30,30);
INSERT INTO person VALUES (29,'Toys-r-cool Store 99','1-610-555-4386','[email protected]');
INSERT INTO tempcustomer VALUES (29,9,9);
INSERT INTO person VALUES (30,'Donna Tyler','1-935-555-5155','[email protected]');
INSERT INTO tempcustomer VALUES (30,28,28);
INSERT INTO person VALUES (31,'Thomas Meyer','1-858-555-7517','[email protected]');
INSERT INTO tempcustomer VALUES (31,19,19);
INSERT INTO person VALUES (32,'Joseph Torres','1-452-555-9197','[email protected]');
INSERT INTO tempcustomer VALUES (32,69,69);
INSERT INTO person VALUES (33,'Yolanda Miranda','1-638-555-9560','[email protected]');
INSERT INTO tempcustomer VALUES (33,52,52);
INSERT INTO person VALUES (34,'Isabella Taylor','1-341-555-8348','[email protected]');
INSERT INTO tempcustomer VALUES (34,64,64);
INSERT INTO person VALUES (35,'Kari Reed','1-312-555-2504','[email protected]');
INSERT INTO tempcustomer VALUES (35,81,81);
INSERT INTO person VALUES (36,'Bryan Turner','1-810-555-1040','[email protected]');
INSERT INTO tempcustomer VALUES (36,50,50);
INSERT INTO person VALUES (37,'Jeremy Phillips','1-679-555-8669','[email protected]');
INSERT INTO tempcustomer VALUES (37,33,33);
INSERT INTO person VALUES (38,'Julie Mann','1-898-555-8797','[email protected]');
INSERT INTO tempcustomer VALUES (38,97,97);
INSERT INTO person VALUES (39,'Tanya Gregory','1-314-555-4808','[email protected]');
INSERT INTO tempcustomer VALUES (39,56,56);
INSERT INTO person VALUES (40,'Javier Wells','1-203-555-4315','[email protected]');
INSERT INTO tempcustomer VALUES (40,65,65);
INSERT INTO person VALUES (41,'Jordan Dean','1-308-555-4889','[email protected]');
INSERT INTO tempcustomer VALUES (41,108,108);
INSERT INTO person VALUES (42,'Jacob Jenkins','1-403-555-2504','[email protected]');
INSERT INTO tempcustomer VALUES (42,48,48);
INSERT INTO person VALUES (43,'Kayla Welch','1-743-555-0009','[email protected]');
INSERT INTO tempcustomer VALUES (43,77,77);
INSERT INTO person VALUES (44,'Julie Murray','1-219-555-1832','[email protected]');
INSERT INTO tempcustomer VALUES (44,47,47);
INSERT INTO person VALUES (45,'Bailey Allen','1-259-555-3946','[email protected]');
INSERT INTO tempcustomer VALUES (45,113,113);
INSERT INTO person VALUES (46,'Christopher Bradford','1-949-555-7962','[email protected]');
INSERT INTO tempcustomer VALUES (46,105,105);
INSERT INTO person VALUES (47,'Toys-r-cool Store 555','1-984-555-2060','[email protected]');
INSERT INTO tempcustomer VALUES (47,17,17);
INSERT INTO person VALUES (48,'William White','1-369-555-4342','[email protected]');
INSERT INTO tempcustomer VALUES (48,68,68);
INSERT INTO person VALUES (49,'Gina Fowler','1-752-555-3295','[email protected]');
INSERT INTO tempcustomer VALUES (49,92,92);
INSERT INTO person VALUES (50,'David Bonilla','1-887-555-6118','[email protected]');
INSERT INTO tempcustomer VALUES (50,57,57);
INSERT INTO person VALUES (51,'Jason Coleman','1-323-555-4061','[email protected]');
INSERT INTO tempcustomer VALUES (51,29,29);
INSERT INTO person VALUES (52,'Philip Clark','1-221-555-9638','[email protected]');
INSERT INTO tempcustomer VALUES (52,71,71);
INSERT INTO person VALUES (53,'William Knapp','1-425-555-0117','[email protected]');
INSERT INTO tempcustomer VALUES (53,10,10);
INSERT INTO person VALUES (54,'Carlos Lewis','1-269-555-0514','[email protected]');
INSERT INTO tempcustomer VALUES (54,111,111);
INSERT INTO person VALUES (55,'Crystal Bishop','1-726-555-3899','[email protected]');
INSERT INTO tempcustomer VALUES (55,36,36);
INSERT INTO person VALUES (56,'Jeffrey Steele','1-752-555-2167','[email protected]');
INSERT INTO tempcustomer VALUES (56,93,93);
INSERT INTO person VALUES (57,'Matthew Fleming','1-684-555-6669','[email protected]');
INSERT INTO tempcustomer VALUES (57,25,25);
INSERT INTO person VALUES (58,'Andres Sullivan','1-874-555-7062','[email protected]');
INSERT INTO tempcustomer VALUES (58,46,46);
INSERT INTO person VALUES (59,'Alejandro Edwards','1-678-555-0887','[email protected]');
INSERT INTO tempcustomer VALUES (59,87,87);
INSERT INTO person VALUES (60,'Thomas Contreras','1-612-555-5559','[email protected]');
INSERT INTO tempcustomer VALUES (60,103,103);
INSERT INTO person VALUES (61,'Steven Sandoval','1-396-555-3116','[email protected]');
INSERT INTO tempcustomer VALUES (61,69,69);
INSERT INTO person VALUES (62,'Brandon Jones','1-632-555-3006','[email protected]');
INSERT INTO tempcustomer VALUES (62,36,36);
INSERT INTO person VALUES (63,'Jessica Miller','1-277-555-7260','[email protected]');
INSERT INTO tempcustomer VALUES (63,104,104);
INSERT INTO person VALUES (64,'Mega Big Box Store 501','1-867-555-8856','[email protected]');
INSERT INTO tempcustomer VALUES (64,108,108);
INSERT INTO person VALUES (65,'Mega Big Box Store 523','1-971-555-3872','[email protected]');
INSERT INTO tempcustomer VALUES (65,22,22);
INSERT INTO person VALUES (66,'Mega Big Box Store 574','1-692-555-3502','[email protected]');
INSERT INTO tempcustomer VALUES (66,111,111);
INSERT INTO person VALUES (67,'Thomas Nolan','1-368-555-6209','[email protected]');
INSERT INTO tempcustomer VALUES (67,1,2);
INSERT INTO person VALUES (68,'Terry Mckinney','1-665-555-4673','[email protected]');
INSERT INTO tempcustomer VALUES (68,55,55);
INSERT INTO person VALUES (69,'Suzanne Johnson','1-394-555-4861','[email protected]');
INSERT INTO tempcustomer VALUES (69,28,28);
INSERT INTO person VALUES (70,'Melissa Sanders','1-953-555-8883','[email protected]');
INSERT INTO tempcustomer VALUES (70,8,8);
INSERT INTO person VALUES (71,'Lisa Lewis','1-251-555-9571','[email protected]');
INSERT INTO tempcustomer VALUES (71,62,62);
INSERT INTO person VALUES (72,'Tyler Clark','1-361-555-0931','[email protected]');
INSERT INTO tempcustomer VALUES (72,66,66);
INSERT INTO person VALUES (73,'Michael Fritz','1-270-555-9749','[email protected]');
INSERT INTO tempcustomer VALUES (73,9,9);
INSERT INTO person VALUES (74,'Dawn Murillo','1-322-555-9333','[email protected]');
INSERT INTO tempcustomer VALUES (74,32,32);
INSERT INTO person VALUES (75,'Chelsea Graves','1-283-555-6868','[email protected]');
INSERT INTO tempcustomer VALUES (75,85,85);
INSERT INTO person VALUES (76,'Tabitha Morgan','1-467-555-3346','[email protected]');
INSERT INTO tempcustomer VALUES (76,86,87);
INSERT INTO person VALUES (77,'Walter Horne','1-471-555-6484','[email protected]');
INSERT INTO tempcustomer VALUES (77,17,17);
INSERT INTO person VALUES (78,'Joseph Horn','1-523-555-1188','[email protected]');
INSERT INTO tempcustomer VALUES (78,2,2);
INSERT INTO person VALUES (79,'Joseph Hunter','1-776-555-1638','[email protected]');
INSERT INTO tempcustomer VALUES (79,10,10);
INSERT INTO person VALUES (80,'Susan Bell','1-718-555-4345','[email protected]');
INSERT INTO tempcustomer VALUES (80,17,17);
INSERT INTO person VALUES (81,'Jonathan Cuevas','1-450-555-6054','[email protected]');
INSERT INTO tempcustomer VALUES (81,37,37);
INSERT INTO person VALUES (82,'Troy Young','1-756-555-4956','[email protected]');
INSERT INTO tempcustomer VALUES (82,79,79);
INSERT INTO person VALUES (83,'April Barnes','1-883-555-9086','[email protected]');
INSERT INTO tempcustomer VALUES (83,39,39);
INSERT INTO person VALUES (84,'Yolanda Robbins','1-470-555-1891','[email protected]');
INSERT INTO tempcustomer VALUES (84,114,114);
INSERT INTO person VALUES (85,'Daniel Wolf','1-359-555-4462','[email protected]');
INSERT INTO tempcustomer VALUES (85,37,37);
INSERT INTO person VALUES (86,'Jennifer Schultz','1-408-555-4325','[email protected]');
INSERT INTO tempcustomer VALUES (86,65,65);
INSERT INTO person VALUES (87,'Michael Fuller','1-252-555-1512','[email protected]');
INSERT INTO tempcustomer VALUES (87,82,82);
INSERT INTO person VALUES (88,'Cheryl Bennett','1-245-555-0058','[email protected]');
INSERT INTO tempcustomer VALUES (88,43,43);
INSERT INTO person VALUES (89,'Shannon Woods','1-365-555-7239','[email protected]');
INSERT INTO tempcustomer VALUES (89,71,71);
INSERT INTO person VALUES (90,'Richard Chandler','1-209-555-1832','[email protected]');
INSERT INTO tempcustomer VALUES (90,10,10);
INSERT INTO person VALUES (91,'Oscar Warner','1-236-555-6049','[email protected]');
INSERT INTO tempcustomer VALUES (91,75,75);
INSERT INTO person VALUES (92,'Stephanie George','1-330-555-0685','[email protected]');
INSERT INTO tempcustomer VALUES (92,40,40);
INSERT INTO person VALUES (93,'Kevin Mercado Jr.','1-566-555-3441','[email protected]');
INSERT INTO tempcustomer VALUES (93,88,89);
INSERT INTO person VALUES (94,'Christina Whitaker','1-562-555-9173','[email protected]');
INSERT INTO tempcustomer VALUES (94,114,114);
INSERT INTO person VALUES (95,'Matthew Nixon','1-967-555-2532','[email protected]');
INSERT INTO tempcustomer VALUES (95,31,31);
INSERT INTO person VALUES (96,'Megan Washington','1-622-555-0406','[email protected]');
INSERT INTO tempcustomer VALUES (96,23,23);
INSERT INTO person VALUES (97,'Heather Carlson','1-885-555-4065','[email protected]');
INSERT INTO tempcustomer VALUES (97,35,35);
INSERT INTO person VALUES (98,'Timothy Curry','1-591-555-0634','[email protected]');
INSERT INTO tempcustomer VALUES (98,110,110);
INSERT INTO person VALUES (99,'Jackie Jones','1-404-555-7541','[email protected]');
INSERT INTO tempcustomer VALUES (99,45,45);
INSERT INTO person VALUES (100,'Kristin Kline','1-428-555-0387','[email protected]');
INSERT INTO tempcustomer VALUES (100,85,85);
INSERT INTO person VALUES (101,'Kristen Martinez','1-536-555-4564','[email protected]');
INSERT INTO tempcustomer VALUES (101,111,111);
INSERT INTO person VALUES (102,'Charles Willis','1-559-555-8346','[email protected]');
INSERT INTO tempcustomer VALUES (102,52,52);
INSERT INTO person VALUES (103,'Adam Noble','1-228-555-1889','[email protected]');
INSERT INTO tempcustomer VALUES (103,113,113);
INSERT INTO person VALUES (104,'Danielle Le','1-794-555-4349','[email protected]');
INSERT INTO tempcustomer VALUES (104,5,5);
INSERT INTO person VALUES (105,'Karen Hodge','1-644-555-5663','[email protected]');
INSERT INTO tempcustomer VALUES (105,94,94);
INSERT INTO person VALUES (106,'Ashley Butler','1-820-555-8379','[email protected]');
INSERT INTO tempcustomer VALUES (106,15,15);
INSERT INTO person VALUES (107,'Lynn Miller','1-394-555-4173','[email protected]');
INSERT INTO tempcustomer VALUES (107,6,6);
INSERT INTO person VALUES (108,'Jessica Love','1-732-555-8821','[email protected]');
INSERT INTO tempcustomer VALUES (108,88,89);
INSERT INTO person VALUES (109,'Glenda Jones','1-641-555-1146','[email protected]');
INSERT INTO tempcustomer VALUES (109,86,87);
INSERT INTO person VALUES (110,'John Thompson','1-521-555-2041','[email protected]');
INSERT INTO tempcustomer VALUES (110,93,93);
INSERT INTO person VALUES (111,'Robert Evans','1-516-555-6691','[email protected]');
INSERT INTO tempcustomer VALUES (111,42,42);
INSERT INTO person VALUES (112,'Michael Williams','1-767-555-2085','[email protected]');
INSERT INTO tempcustomer VALUES (112,25,25);
INSERT INTO person VALUES (113,'Toys-r-cool Store 42','1-893-555-2851','[email protected]');
INSERT INTO tempcustomer VALUES (113,79,79);
INSERT INTO person VALUES (114,'Christopher Bates','1-761-555-0006','[email protected]');
INSERT INTO tempcustomer VALUES (114,39,39);
INSERT INTO person VALUES (115,'Maria Flores','1-640-555-9502','[email protected]');
INSERT INTO tempcustomer VALUES (115,78,78);
INSERT INTO person VALUES (116,'Amy Frank','1-652-555-7244','[email protected]');
INSERT INTO tempcustomer VALUES (116,87,87);
INSERT INTO person VALUES (117,'Dalton Acosta','1-684-555-2780','[email protected]');
INSERT INTO tempcustomer VALUES (117,85,85);
INSERT INTO person VALUES (118,'Miss Ashley Hahn','1-727-555-5491','[email protected]');
INSERT INTO tempcustomer VALUES (118,12,12);
INSERT INTO person VALUES (119,'Albert Gibson','1-430-555-3262','[email protected]');
INSERT INTO tempcustomer VALUES (119,19,19);
INSERT INTO person VALUES (120,'Paula Herrera','1-450-555-7784','[email protected]');
INSERT INTO tempcustomer VALUES (120,79,79);
INSERT INTO person VALUES (121,'Todd Gonzales','1-624-555-9431','[email protected]');
INSERT INTO tempcustomer VALUES (121,25,25);
INSERT INTO person VALUES (122,'Leslie Russo','1-609-555-3997','[email protected]');
INSERT INTO tempcustomer VALUES (122,19,19);
INSERT INTO person VALUES (123,'Regina Alexander','1-635-555-3585','[email protected]');
INSERT INTO tempcustomer VALUES (123,23,23);
INSERT INTO person VALUES (124,'Bob May','1-251-555-9132','[email protected]');
INSERT INTO tempcustomer VALUES (124,32,32);
INSERT INTO person VALUES (125,'Robert Nielsen','1-336-555-7612','[email protected]');
INSERT INTO tempcustomer VALUES (125,86,87);
INSERT INTO person VALUES (126,'Todd Holt','1-809-555-5198','[email protected]');
INSERT INTO tempcustomer VALUES (126,97,97);
INSERT INTO person VALUES (127,'Tiffany Silva','1-936-555-8270','[email protected]');
INSERT INTO tempcustomer VALUES (127,55,55);
INSERT INTO person VALUES (128,'Jennifer Jones','1-362-555-7777','[email protected]');
INSERT INTO tempcustomer VALUES (128,58,58);
INSERT INTO person VALUES (129,'Elizabeth French','1-852-555-4543','[email protected]');
INSERT INTO tempcustomer VALUES (129,99,99);
INSERT INTO person VALUES (130,'Trevor Smith','1-841-555-3919','[email protected]');
INSERT INTO tempcustomer VALUES (130,36,36);
INSERT INTO person VALUES (131,'Mega Big Box Store 555','1-930-555-4681','[email protected]');
INSERT INTO tempcustomer VALUES (131,31,31);
INSERT INTO person VALUES (132,'Deborah Webb','1-527-555-8849','[email protected]');
INSERT INTO tempcustomer VALUES (132,11,11);
INSERT INTO person VALUES (133,'Toys-r-cool store 345','1-436-555-6275','[email protected]');
INSERT INTO tempcustomer VALUES (133,89,89);
INSERT INTO person VALUES (134,'Melissa Brown','1-265-555-6797','[email protected]');
INSERT INTO tempcustomer VALUES (134,53,53);


insert into customer
SELECT customer_person_id, name, phone, email,
B.street1, B.street2, B.city, B.state_id, B.postal_code, B.country_id, NULL
from tempcustomer
join person on person.person_id = tempcustomer.customer_person_id
join address AS B on B.address_id = tempcustomer.bill_address_id;

update customer set billto_customer_id = 12 where customer_id in (29, 47, 113);
update customer set billto_customer_id = 10 where customer_id in (131, 66, 65, 64, 18);

INSERT INTO order_header VALUES (1001,52,'2023-10-05 17:50', NULL);
INSERT INTO order_detail VALUES (1001,1003,3,8.98);
INSERT INTO order_detail VALUES (1001,1002,4,7.89);
INSERT INTO order_detail VALUES (1001,1018,2,2.95);
INSERT INTO order_detail VALUES (1001,1011,4,3.37);
UPDATE order_header SET total = 77.88 WHERE order_id = 1001;
INSERT INTO order_header VALUES (1002,96,'2023-07-27 09:28', NULL);
INSERT INTO order_detail VALUES (1002,1003,2,15.98);
INSERT INTO order_detail VALUES (1002,1002,2,7.41);
INSERT INTO order_detail VALUES (1002,1019,2,6.13);
INSERT INTO order_detail VALUES (1002,1001,4,9.67);
INSERT INTO order_detail VALUES (1002,1010,4,3.69);
INSERT INTO order_detail VALUES (1002,1022,1,34.78);
UPDATE order_header SET total = 147.26 WHERE order_id = 1002;
INSERT INTO order_header VALUES (1003,16,'2023-06-29 08:07', NULL);
INSERT INTO order_detail VALUES (1003,1003,4,8.98);
INSERT INTO order_detail VALUES (1003,1019,2,5.86);
UPDATE order_header SET total = 47.64 WHERE order_id = 1003;
INSERT INTO order_header VALUES (1004,57,'2023-03-27 23:04', NULL);
INSERT INTO order_detail VALUES (1004,1023,1,26.98);
INSERT INTO order_detail VALUES (1004,1020,2,21.34);
INSERT INTO order_detail VALUES (1004,1001,1,7.89);
INSERT INTO order_detail VALUES (1004,1011,1,3.54);
INSERT INTO order_detail VALUES (1004,1012,3,14.68);
UPDATE order_header SET total = 125.13 WHERE order_id = 1004;
INSERT INTO order_header VALUES (1005,11,'2023-08-04 05:34', NULL);
INSERT INTO order_detail VALUES (1005,1023,4,30.1);
INSERT INTO order_detail VALUES (1005,1022,3,30.35);
INSERT INTO order_detail VALUES (1005,1011,1,3.58);
INSERT INTO order_detail VALUES (1005,1010,4,4.67);
UPDATE order_header SET total = 233.71 WHERE order_id = 1005;
INSERT INTO order_header VALUES (1006,95,'2023-07-14 08:29', NULL);
INSERT INTO order_detail VALUES (1006,1020,1,18.78);
INSERT INTO order_detail VALUES (1006,1022,2,38.61);
INSERT INTO order_detail VALUES (1006,1001,4,7.89);
UPDATE order_header SET total = 127.56 WHERE order_id = 1006;
INSERT INTO order_header VALUES (1007,40,'2023-12-20 23:06', NULL);
INSERT INTO order_detail VALUES (1007,1024,4,43.98);
INSERT INTO order_detail VALUES (1007,1018,3,3.74);
INSERT INTO order_detail VALUES (1007,1003,3,8.77);
INSERT INTO order_detail VALUES (1007,1001,3,12.95);
UPDATE order_header SET total = 252.3 WHERE order_id = 1007;
INSERT INTO order_header VALUES (1008,34,'2023-06-11 23:00', NULL);
INSERT INTO order_detail VALUES (1008,1018,3,2.8);
UPDATE order_header SET total = 8.4 WHERE order_id = 1008;
INSERT INTO order_header VALUES (1009,11,'2023-12-29 19:27', NULL);
INSERT INTO order_detail VALUES (1009,1002,4,7.26);
INSERT INTO order_detail VALUES (1009,1010,1,5.51);
INSERT INTO order_detail VALUES (1009,1022,1,34.78);
INSERT INTO order_detail VALUES (1009,1003,4,16.6);
INSERT INTO order_detail VALUES (1009,1001,1,9.12);
UPDATE order_header SET total = 144.85 WHERE order_id = 1009;
INSERT INTO order_header VALUES (1010,131,'2023-06-05 21:06', NULL);
INSERT INTO order_detail VALUES (1010,1001,1,7.89);
UPDATE order_header SET total = 7.89 WHERE order_id = 1010;
INSERT INTO order_header VALUES (1011,36,'2023-11-17 03:20', NULL);
INSERT INTO order_detail VALUES (1011,1024,4,38.08);
INSERT INTO order_detail VALUES (1011,1003,3,8.98);
UPDATE order_header SET total = 179.26 WHERE order_id = 1011;
INSERT INTO order_header VALUES (1012,68,'2023-02-06 20:59', NULL);
INSERT INTO order_detail VALUES (1012,1018,1,3.82);
INSERT INTO order_detail VALUES (1012,1011,3,3.61);
INSERT INTO order_detail VALUES (1012,1019,3,6.67);
INSERT INTO order_detail VALUES (1012,1001,3,7.89);
INSERT INTO order_detail VALUES (1012,1003,4,9.42);
INSERT INTO order_detail VALUES (1012,1023,4,26.98);
UPDATE order_header SET total = 203.93 WHERE order_id = 1012;
INSERT INTO order_header VALUES (1013,87,'2023-05-09 18:29', NULL);
INSERT INTO order_detail VALUES (1013,1023,3,28.13);
UPDATE order_header SET total = 84.39 WHERE order_id = 1013;
INSERT INTO order_header VALUES (1014,91,'2023-09-09 15:01', NULL);
INSERT INTO order_detail VALUES (1014,1023,3,26.98);
UPDATE order_header SET total = 80.94 WHERE order_id = 1014;
INSERT INTO order_header VALUES (1015,61,'2024-01-25 20:37', NULL);
INSERT INTO order_detail VALUES (1015,1022,4,35.1);
INSERT INTO order_detail VALUES (1015,1003,4,15.98);
INSERT INTO order_detail VALUES (1015,1020,1,19.24);
INSERT INTO order_detail VALUES (1015,1002,3,8.67);
INSERT INTO order_detail VALUES (1015,1012,1,14.56);
UPDATE order_header SET total = 264.13 WHERE order_id = 1015;
INSERT INTO order_header VALUES (1016,112,'2023-05-03 12:47', NULL);
INSERT INTO order_detail VALUES (1016,1010,4,4.67);
INSERT INTO order_detail VALUES (1016,1023,3,26.98);
INSERT INTO order_detail VALUES (1016,1024,3,43.6);
INSERT INTO order_detail VALUES (1016,1002,4,8.09);
INSERT INTO order_detail VALUES (1016,1001,4,8.28);
INSERT INTO order_detail VALUES (1016,1003,2,15.98);
UPDATE order_header SET total = 327.86 WHERE order_id = 1016;
INSERT INTO order_header VALUES (1017,45,'2024-01-31 06:36', NULL);
INSERT INTO order_detail VALUES (1017,1024,4,45.12);
INSERT INTO order_detail VALUES (1017,1023,4,24.58);
INSERT INTO order_detail VALUES (1017,1022,2,34.78);
INSERT INTO order_detail VALUES (1017,1002,2,7.89);
UPDATE order_header SET total = 364.14 WHERE order_id = 1017;
INSERT INTO order_header VALUES (1018,39,'2024-02-02 00:27', NULL);
INSERT INTO order_detail VALUES (1018,1019,1,6.67);
INSERT INTO order_detail VALUES (1018,1020,4,15.44);
INSERT INTO order_detail VALUES (1018,1018,2,3.8);
INSERT INTO order_detail VALUES (1018,1001,3,8.65);
UPDATE order_header SET total = 101.98 WHERE order_id = 1018;
INSERT INTO order_header VALUES (1019,93,'2023-02-11 08:04', NULL);
INSERT INTO order_detail VALUES (1019,1024,4,43.98);
INSERT INTO order_detail VALUES (1019,1001,1,8.66);
INSERT INTO order_detail VALUES (1019,1011,1,4.21);
UPDATE order_header SET total = 188.79 WHERE order_id = 1019;
INSERT INTO order_header VALUES (1020,47,'2023-07-03 14:43', NULL);
INSERT INTO order_detail VALUES (1020,1003,4,8.98);
INSERT INTO order_detail VALUES (1020,1020,2,20.07);
INSERT INTO order_detail VALUES (1020,1019,4,5.03);
UPDATE order_header SET total = 96.18 WHERE order_id = 1020;
INSERT INTO order_header VALUES (1021,112,'2023-08-27 23:22', NULL);
INSERT INTO order_detail VALUES (1021,1003,2,8.98);
INSERT INTO order_detail VALUES (1021,1001,4,7.42);
INSERT INTO order_detail VALUES (1021,1022,3,34.78);
UPDATE order_header SET total = 151.98 WHERE order_id = 1021;
INSERT INTO order_header VALUES (1022,99,'2023-06-01 19:59', NULL);
INSERT INTO order_detail VALUES (1022,1018,3,3.33);
UPDATE order_header SET total = 9.99 WHERE order_id = 1022;
INSERT INTO order_header VALUES (1023,102,'2024-01-28 19:14', NULL);
INSERT INTO order_detail VALUES (1023,1003,1,8.98);
INSERT INTO order_detail VALUES (1023,1002,3,15.98);
INSERT INTO order_detail VALUES (1023,1022,2,39.76);
INSERT INTO order_detail VALUES (1023,1024,3,43.98);
INSERT INTO order_detail VALUES (1023,1020,3,18.78);
INSERT INTO order_detail VALUES (1023,1023,3,26.98);
UPDATE order_header SET total = 405.66 WHERE order_id = 1023;
INSERT INTO order_header VALUES (1024,130,'2023-09-04 03:20', NULL);
INSERT INTO order_detail VALUES (1024,1020,1,15.25);
INSERT INTO order_detail VALUES (1024,1002,3,7.89);
INSERT INTO order_detail VALUES (1024,1003,3,8.98);
UPDATE order_header SET total = 65.86 WHERE order_id = 1024;
INSERT INTO order_header VALUES (1025,115,'2023-11-23 11:18', NULL);
INSERT INTO order_detail VALUES (1025,1012,4,10.56);
INSERT INTO order_detail VALUES (1025,1001,1,7.86);
INSERT INTO order_detail VALUES (1025,1003,1,9.15);
UPDATE order_header SET total = 59.25 WHERE order_id = 1025;
INSERT INTO order_header VALUES (1026,59,'2023-08-21 13:18', NULL);
INSERT INTO order_detail VALUES (1026,1002,3,7.67);
INSERT INTO order_detail VALUES (1026,1018,2,3.33);
INSERT INTO order_detail VALUES (1026,1001,1,7.89);
UPDATE order_header SET total = 37.56 WHERE order_id = 1026;
INSERT INTO order_header VALUES (1027,57,'2023-10-06 23:17', NULL);
INSERT INTO order_detail VALUES (1027,1011,1,3.67);
INSERT INTO order_detail VALUES (1027,1024,2,43.98);
INSERT INTO order_detail VALUES (1027,1001,2,8.94);
INSERT INTO order_detail VALUES (1027,1022,2,34.78);
INSERT INTO order_detail VALUES (1027,1002,2,13.16);
INSERT INTO order_detail VALUES (1027,1003,1,11.15);
UPDATE order_header SET total = 216.54 WHERE order_id = 1027;
INSERT INTO order_header VALUES (1028,26,'2023-10-04 10:12', NULL);
INSERT INTO order_detail VALUES (1028,1003,3,10.07);
INSERT INTO order_detail VALUES (1028,1022,1,34.78);
INSERT INTO order_detail VALUES (1028,1018,4,3.1);
UPDATE order_header SET total = 77.39 WHERE order_id = 1028;
INSERT INTO order_header VALUES (1029,85,'2023-02-25 14:05', NULL);
INSERT INTO order_detail VALUES (1029,1019,4,6.67);
INSERT INTO order_detail VALUES (1029,1018,4,3.33);
INSERT INTO order_detail VALUES (1029,1022,4,27.49);
INSERT INTO order_detail VALUES (1029,1023,2,23.94);
UPDATE order_header SET total = 197.84 WHERE order_id = 1029;
INSERT INTO order_header VALUES (1030,91,'2023-10-27 11:17', NULL);
INSERT INTO order_detail VALUES (1030,1018,2,3.98);
INSERT INTO order_detail VALUES (1030,1022,4,33.97);
INSERT INTO order_detail VALUES (1030,1019,4,6.67);
INSERT INTO order_detail VALUES (1030,1011,3,3.97);
INSERT INTO order_detail VALUES (1030,1002,3,7.89);
UPDATE order_header SET total = 206.1 WHERE order_id = 1030;
INSERT INTO order_header VALUES (1031,97,'2023-08-31 10:04', NULL);
INSERT INTO order_detail VALUES (1031,1011,1,4.36);
UPDATE order_header SET total = 4.36 WHERE order_id = 1031;
INSERT INTO order_header VALUES (1032,130,'2024-01-20 07:30', NULL);
INSERT INTO order_detail VALUES (1032,1019,2,6.67);
INSERT INTO order_detail VALUES (1032,1018,3,3.33);
INSERT INTO order_detail VALUES (1032,1003,3,7.99);
INSERT INTO order_detail VALUES (1032,1024,2,43.98);
UPDATE order_header SET total = 135.26 WHERE order_id = 1032;
INSERT INTO order_header VALUES (1033,118,'2023-10-15 15:40', NULL);
INSERT INTO order_detail VALUES (1033,1022,1,28.58);
INSERT INTO order_detail VALUES (1033,1024,4,49.28);
INSERT INTO order_detail VALUES (1033,1001,1,8.01);
INSERT INTO order_detail VALUES (1033,1012,4,12.58);
INSERT INTO order_detail VALUES (1033,1003,3,8.19);
UPDATE order_header SET total = 308.6 WHERE order_id = 1033;
INSERT INTO order_header VALUES (1034,130,'2023-10-18 01:27', NULL);
INSERT INTO order_detail VALUES (1034,1019,4,7.52);
INSERT INTO order_detail VALUES (1034,1003,1,12.87);
INSERT INTO order_detail VALUES (1034,1020,4,18.78);
INSERT INTO order_detail VALUES (1034,1001,3,8.51);
INSERT INTO order_detail VALUES (1034,1018,1,3.0);
UPDATE order_header SET total = 146.6 WHERE order_id = 1034;
INSERT INTO order_header VALUES (1035,37,'2024-01-28 09:42', NULL);
INSERT INTO order_detail VALUES (1035,1020,2,18.78);
INSERT INTO order_detail VALUES (1035,1001,3,9.32);
UPDATE order_header SET total = 65.52 WHERE order_id = 1035;
INSERT INTO order_header VALUES (1036,15,'2023-08-12 02:04', NULL);
INSERT INTO order_detail VALUES (1036,1010,1,4.67);
UPDATE order_header SET total = 4.67 WHERE order_id = 1036;
INSERT INTO order_header VALUES (1037,31,'2023-11-13 04:34', NULL);
INSERT INTO order_detail VALUES (1037,1019,3,7.6);
INSERT INTO order_detail VALUES (1037,1020,1,18.78);
INSERT INTO order_detail VALUES (1037,1003,1,8.98);
INSERT INTO order_detail VALUES (1037,1010,2,4.67);
UPDATE order_header SET total = 59.9 WHERE order_id = 1037;
INSERT INTO order_header VALUES (1038,54,'2023-06-29 06:01', NULL);
INSERT INTO order_detail VALUES (1038,1001,2,7.89);
INSERT INTO order_detail VALUES (1038,1019,4,6.88);
INSERT INTO order_detail VALUES (1038,1011,4,3.67);
INSERT INTO order_detail VALUES (1038,1002,3,7.89);
INSERT INTO order_detail VALUES (1038,1023,3,21.16);
INSERT INTO order_detail VALUES (1038,1003,4,15.98);
UPDATE order_header SET total = 209.05 WHERE order_id = 1038;
INSERT INTO order_header VALUES (1039,111,'2023-05-21 22:48', NULL);
INSERT INTO order_detail VALUES (1039,1022,1,34.78);
INSERT INTO order_detail VALUES (1039,1010,4,4.8);
INSERT INTO order_detail VALUES (1039,1020,1,21.69);
INSERT INTO order_detail VALUES (1039,1011,2,3.63);
INSERT INTO order_detail VALUES (1039,1003,2,8.98);
UPDATE order_header SET total = 100.89 WHERE order_id = 1039;
INSERT INTO order_header VALUES (1040,67,'2023-02-22 16:49', NULL);
INSERT INTO order_detail VALUES (1040,1024,3,50.02);
INSERT INTO order_detail VALUES (1040,1019,1,6.67);
INSERT INTO order_detail VALUES (1040,1003,3,7.16);
UPDATE order_header SET total = 178.21 WHERE order_id = 1040;
INSERT INTO order_header VALUES (1041,96,'2023-07-17 01:07', NULL);
INSERT INTO order_detail VALUES (1041,1018,2,3.33);
INSERT INTO order_detail VALUES (1041,1001,1,7.4);
INSERT INTO order_detail VALUES (1041,1011,3,3.67);
UPDATE order_header SET total = 25.07 WHERE order_id = 1041;
INSERT INTO order_header VALUES (1042,95,'2023-12-26 06:16', NULL);
INSERT INTO order_detail VALUES (1042,1019,4,8.34);
INSERT INTO order_detail VALUES (1042,1022,2,40.77);
INSERT INTO order_detail VALUES (1042,1020,1,18.78);
INSERT INTO order_detail VALUES (1042,1002,1,7.89);
INSERT INTO order_detail VALUES (1042,1012,2,13.67);
INSERT INTO order_detail VALUES (1042,1011,2,4.28);
UPDATE order_header SET total = 177.47 WHERE order_id = 1042;
INSERT INTO order_header VALUES (1043,108,'2023-11-16 01:49', NULL);
INSERT INTO order_detail VALUES (1043,1022,3,34.78);
INSERT INTO order_detail VALUES (1043,1010,4,4.67);
UPDATE order_header SET total = 123.02 WHERE order_id = 1043;
INSERT INTO order_header VALUES (1044,34,'2023-07-08 16:19', NULL);
INSERT INTO order_detail VALUES (1044,1001,4,7.89);
INSERT INTO order_detail VALUES (1044,1022,1,34.78);
INSERT INTO order_detail VALUES (1044,1024,1,49.77);
INSERT INTO order_detail VALUES (1044,1012,3,13.76);
INSERT INTO order_detail VALUES (1044,1003,4,10.82);
INSERT INTO order_detail VALUES (1044,1019,4,6.67);
UPDATE order_header SET total = 227.35 WHERE order_id = 1044;
INSERT INTO order_header VALUES (1045,129,'2023-01-14 16:27', NULL);
INSERT INTO order_detail VALUES (1045,1020,3,18.78);
INSERT INTO order_detail VALUES (1045,1003,2,19.31);
INSERT INTO order_detail VALUES (1045,1024,4,8.98);
INSERT INTO order_detail VALUES (1045,1011,2,3.67);
UPDATE order_header SET total = 138.22 WHERE order_id = 1045;
INSERT INTO order_header VALUES (1046,70,'2023-08-18 14:20', NULL);
INSERT INTO order_detail VALUES (1046,1002,2,6.11);
INSERT INTO order_detail VALUES (1046,1010,4,4.67);
INSERT INTO order_detail VALUES (1046,1023,4,31.52);
INSERT INTO order_detail VALUES (1046,1012,4,13.67);
INSERT INTO order_detail VALUES (1046,1018,1,3.33);
UPDATE order_header SET total = 214.99 WHERE order_id = 1046;
INSERT INTO order_header VALUES (1047,83,'2023-05-04 02:38', NULL);
INSERT INTO order_detail VALUES (1047,1011,1,3.67);
INSERT INTO order_detail VALUES (1047,1001,1,7.77);
INSERT INTO order_detail VALUES (1047,1020,4,18.78);
INSERT INTO order_detail VALUES (1047,1022,3,34.78);
INSERT INTO order_detail VALUES (1047,1010,3,4.67);
INSERT INTO order_detail VALUES (1047,1003,3,9.69);
UPDATE order_header SET total = 233.98 WHERE order_id = 1047;
INSERT INTO order_header VALUES (1048,23,'2024-01-31 16:36', NULL);
INSERT INTO order_detail VALUES (1048,1002,2,7.89);
INSERT INTO order_detail VALUES (1048,1010,1,4.67);
INSERT INTO order_detail VALUES (1048,1019,4,5.67);
INSERT INTO order_detail VALUES (1048,1022,2,34.78);
INSERT INTO order_detail VALUES (1048,1001,3,7.89);
UPDATE order_header SET total = 136.36 WHERE order_id = 1048;
INSERT INTO order_header VALUES (1049,75,'2023-07-23 22:12', NULL);
INSERT INTO order_detail VALUES (1049,1011,4,3.67);
INSERT INTO order_detail VALUES (1049,1010,4,4.67);
INSERT INTO order_detail VALUES (1049,1018,4,2.81);
INSERT INTO order_detail VALUES (1049,1023,4,30.99);
INSERT INTO order_detail VALUES (1049,1019,3,6.67);
UPDATE order_header SET total = 188.57 WHERE order_id = 1049;
INSERT INTO order_header VALUES (1050,103,'2023-08-06 17:53', NULL);
INSERT INTO order_detail VALUES (1050,1012,4,13.29);
UPDATE order_header SET total = 53.16 WHERE order_id = 1050;
INSERT INTO order_header VALUES (1051,67,'2023-01-22 02:07', NULL);
INSERT INTO order_detail VALUES (1051,1020,1,19.79);
INSERT INTO order_detail VALUES (1051,1019,4,5.23);
INSERT INTO order_detail VALUES (1051,1022,3,42.6);
INSERT INTO order_detail VALUES (1051,1010,1,4.67);
INSERT INTO order_detail VALUES (1051,1001,4,7.89);
INSERT INTO order_detail VALUES (1051,1018,3,2.63);
UPDATE order_header SET total = 212.63 WHERE order_id = 1051;
INSERT INTO order_header VALUES (1052,27,'2023-09-29 22:12', NULL);
INSERT INTO order_detail VALUES (1052,1024,1,38.71);
INSERT INTO order_detail VALUES (1052,1002,4,8.33);
INSERT INTO order_detail VALUES (1052,1022,4,28.45);
UPDATE order_header SET total = 185.83 WHERE order_id = 1052;
INSERT INTO order_header VALUES (1053,19,'2023-08-20 22:00', NULL);
INSERT INTO order_detail VALUES (1053,1003,3,15.98);
INSERT INTO order_detail VALUES (1053,1012,1,13.67);
UPDATE order_header SET total = 61.61 WHERE order_id = 1053;
INSERT INTO order_header VALUES (1054,111,'2023-03-13 14:33', NULL);
INSERT INTO order_detail VALUES (1054,1024,4,43.98);
INSERT INTO order_detail VALUES (1054,1019,4,6.67);
UPDATE order_header SET total = 202.6 WHERE order_id = 1054;
INSERT INTO order_header VALUES (1055,108,'2023-07-29 23:00', NULL);
INSERT INTO order_detail VALUES (1055,1002,2,9.51);
INSERT INTO order_detail VALUES (1055,1024,1,43.98);
INSERT INTO order_detail VALUES (1055,1010,2,3.88);
INSERT INTO order_detail VALUES (1055,1020,2,22.92);
INSERT INTO order_detail VALUES (1055,1011,3,3.67);
UPDATE order_header SET total = 127.61 WHERE order_id = 1055;
INSERT INTO order_header VALUES (1056,42,'2023-04-11 04:45', NULL);
INSERT INTO order_detail VALUES (1056,1022,1,34.78);
INSERT INTO order_detail VALUES (1056,1020,1,22.99);
INSERT INTO order_detail VALUES (1056,1002,3,7.89);
INSERT INTO order_detail VALUES (1056,1003,4,15.98);
INSERT INTO order_detail VALUES (1056,1001,1,8.39);
INSERT INTO order_detail VALUES (1056,1012,3,13.67);
UPDATE order_header SET total = 194.76 WHERE order_id = 1056;
INSERT INTO order_header VALUES (1057,48,'2023-09-05 03:26', NULL);
INSERT INTO order_detail VALUES (1057,1011,4,3.87);
INSERT INTO order_detail VALUES (1057,1002,3,7.89);
UPDATE order_header SET total = 39.15 WHERE order_id = 1057;
INSERT INTO order_header VALUES (1058,50,'2024-01-11 11:53', NULL);
INSERT INTO order_detail VALUES (1058,1019,2,5.17);
INSERT INTO order_detail VALUES (1058,1003,4,8.98);
INSERT INTO order_detail VALUES (1058,1018,4,3.94);
UPDATE order_header SET total = 62.02 WHERE order_id = 1058;
INSERT INTO order_header VALUES (1059,30,'2023-06-17 10:38', NULL);
INSERT INTO order_detail VALUES (1059,1012,4,13.67);
INSERT INTO order_detail VALUES (1059,1003,2,8.98);
INSERT INTO order_detail VALUES (1059,1001,1,15.94);
INSERT INTO order_detail VALUES (1059,1019,4,5.03);
INSERT INTO order_detail VALUES (1059,1010,1,5.56);
UPDATE order_header SET total = 114.26 WHERE order_id = 1059;
INSERT INTO order_header VALUES (1060,103,'2023-07-07 14:32', NULL);
INSERT INTO order_detail VALUES (1060,1001,3,7.89);
INSERT INTO order_detail VALUES (1060,1023,1,21.54);
INSERT INTO order_detail VALUES (1060,1003,3,8.98);
INSERT INTO order_detail VALUES (1060,1018,3,3.33);
UPDATE order_header SET total = 82.14 WHERE order_id = 1060;
INSERT INTO order_header VALUES (1061,56,'2024-01-22 16:27', NULL);
INSERT INTO order_detail VALUES (1061,1010,2,4.67);
INSERT INTO order_detail VALUES (1061,1024,2,46.47);
UPDATE order_header SET total = 102.28 WHERE order_id = 1061;
INSERT INTO order_header VALUES (1062,30,'2023-07-21 17:20', NULL);
INSERT INTO order_detail VALUES (1062,1019,3,6.67);
INSERT INTO order_detail VALUES (1062,1024,4,43.98);
INSERT INTO order_detail VALUES (1062,1010,1,4.67);
INSERT INTO order_detail VALUES (1062,1003,3,8.98);
INSERT INTO order_detail VALUES (1062,1011,2,3.67);
UPDATE order_header SET total = 234.88 WHERE order_id = 1062;
INSERT INTO order_header VALUES (1063,84,'2023-09-03 21:28', NULL);
INSERT INTO order_detail VALUES (1063,1020,3,17.96);
INSERT INTO order_detail VALUES (1063,1001,2,8.97);
UPDATE order_header SET total = 71.82 WHERE order_id = 1063;
INSERT INTO order_header VALUES (1064,127,'2023-08-30 15:14', NULL);
INSERT INTO order_detail VALUES (1064,1012,4,13.67);
INSERT INTO order_detail VALUES (1064,1022,3,34.78);
INSERT INTO order_detail VALUES (1064,1001,3,7.89);
INSERT INTO order_detail VALUES (1064,1019,2,6.67);
INSERT INTO order_detail VALUES (1064,1023,3,26.98);
INSERT INTO order_detail VALUES (1064,1002,2,7.89);
UPDATE order_header SET total = 292.75 WHERE order_id = 1064;
INSERT INTO order_header VALUES (1066,42,'2024-01-18 23:08', NULL);
INSERT INTO order_detail VALUES (1066,1019,2,6.67);
INSERT INTO order_detail VALUES (1066,1012,1,12.51);
INSERT INTO order_detail VALUES (1066,1024,4,49.93);
INSERT INTO order_detail VALUES (1066,1023,1,26.98);
UPDATE order_header SET total = 252.55 WHERE order_id = 1066;
INSERT INTO order_header VALUES (1068,33,'2024-01-19 01:47', NULL);
INSERT INTO order_detail VALUES (1068,1024,3,35.46);
INSERT INTO order_detail VALUES (1068,1010,2,4.67);
INSERT INTO order_detail VALUES (1068,1002,3,7.89);
UPDATE order_header SET total = 139.39 WHERE order_id = 1068;
INSERT INTO order_header VALUES (1069,11,'2024-01-13 04:31', NULL);
INSERT INTO order_detail VALUES (1069,1011,1,3.01);
INSERT INTO order_detail VALUES (1069,1010,3,4.67);
INSERT INTO order_detail VALUES (1069,1024,1,38.16);
UPDATE order_header SET total = 55.18 WHERE order_id = 1069;
INSERT INTO order_header VALUES (1070,106,'2023-05-17 12:00', NULL);
INSERT INTO order_detail VALUES (1070,1001,2,7.9);
INSERT INTO order_detail VALUES (1070,1024,3,43.98);
INSERT INTO order_detail VALUES (1070,1003,3,7.73);
UPDATE order_header SET total = 170.93 WHERE order_id = 1070;
INSERT INTO order_header VALUES (1071,132,'2023-03-10 20:28', NULL);
INSERT INTO order_detail VALUES (1071,1002,4,7.89);
INSERT INTO order_detail VALUES (1071,1001,3,8.14);
INSERT INTO order_detail VALUES (1071,1018,1,3.33);
INSERT INTO order_detail VALUES (1071,1020,2,18.78);
UPDATE order_header SET total = 96.87 WHERE order_id = 1071;
INSERT INTO order_header VALUES (1072,29,'2023-03-26 23:20', NULL);
INSERT INTO order_detail VALUES (1072,1018,4,3.33);
INSERT INTO order_detail VALUES (1072,1003,4,8.98);
INSERT INTO order_detail VALUES (1072,1012,3,13.67);
UPDATE order_header SET total = 90.25 WHERE order_id = 1072;
INSERT INTO order_header VALUES (1073,60,'2023-05-11 16:18', NULL);
INSERT INTO order_detail VALUES (1073,1011,1,3.08);
UPDATE order_header SET total = 3.08 WHERE order_id = 1073;
INSERT INTO order_header VALUES (1074,27,'2024-01-28 01:50', NULL);
INSERT INTO order_detail VALUES (1074,1001,3,9.83);
INSERT INTO order_detail VALUES (1074,1019,4,6.67);
INSERT INTO order_detail VALUES (1074,1022,2,34.78);
INSERT INTO order_detail VALUES (1074,1011,1,3.67);
INSERT INTO order_detail VALUES (1074,1003,4,8.98);
INSERT INTO order_detail VALUES (1074,1002,4,7.89);
UPDATE order_header SET total = 196.88 WHERE order_id = 1074;
INSERT INTO order_header VALUES (1075,115,'2023-04-28 00:11', NULL);
INSERT INTO order_detail VALUES (1075,1023,1,20.69);
INSERT INTO order_detail VALUES (1075,1012,1,10.55);
UPDATE order_header SET total = 31.24 WHERE order_id = 1075;
INSERT INTO order_header VALUES (1076,66,'2023-04-30 03:27', NULL);
INSERT INTO order_detail VALUES (1076,1002,2,6.48);
INSERT INTO order_detail VALUES (1076,1012,2,12.13);
INSERT INTO order_detail VALUES (1076,1019,2,6.67);
INSERT INTO order_detail VALUES (1076,1022,4,34.78);
INSERT INTO order_detail VALUES (1076,1003,1,8.98);
UPDATE order_header SET total = 198.66 WHERE order_id = 1076;
INSERT INTO order_header VALUES (1077,130,'2023-11-26 04:24', NULL);
INSERT INTO order_detail VALUES (1077,1003,3,8.98);
INSERT INTO order_detail VALUES (1077,1023,2,26.98);
INSERT INTO order_detail VALUES (1077,1002,1,7.89);
INSERT INTO order_detail VALUES (1077,1010,4,4.67);
INSERT INTO order_detail VALUES (1077,1012,2,12.0);
INSERT INTO order_detail VALUES (1077,1022,3,34.78);
UPDATE order_header SET total = 235.81 WHERE order_id = 1077;
INSERT INTO order_header VALUES (1078,128,'2023-08-19 14:55', NULL);
INSERT INTO order_detail VALUES (1078,1001,2,9.35);
INSERT INTO order_detail VALUES (1078,1002,3,9.5);
INSERT INTO order_detail VALUES (1078,1020,2,18.78);
UPDATE order_header SET total = 84.76 WHERE order_id = 1078;
INSERT INTO order_header VALUES (1079,133,'2024-01-15 02:05', NULL);
INSERT INTO order_detail VALUES (1079,1001,3,7.34);
UPDATE order_header SET total = 22.02 WHERE order_id = 1079;
INSERT INTO order_header VALUES (1080,122,'2023-09-12 10:52', NULL);
INSERT INTO order_detail VALUES (1080,1018,1,4.05);
INSERT INTO order_detail VALUES (1080,1020,4,15.93);
INSERT INTO order_detail VALUES (1080,1002,2,9.21);
INSERT INTO order_detail VALUES (1080,1011,4,3.67);
UPDATE order_header SET total = 100.87 WHERE order_id = 1080;
INSERT INTO order_header VALUES (1081,130,'2023-12-17 03:25', NULL);
INSERT INTO order_detail VALUES (1081,1018,2,3.33);
INSERT INTO order_detail VALUES (1081,1011,1,3.67);
INSERT INTO order_detail VALUES (1081,1023,1,26.98);
UPDATE order_header SET total = 37.31 WHERE order_id = 1081;
INSERT INTO order_header VALUES (1082,95,'2023-01-25 00:39', NULL);
INSERT INTO order_detail VALUES (1082,1002,4,7.89);
UPDATE order_header SET total = 31.56 WHERE order_id = 1082;
INSERT INTO order_header VALUES (1083,101,'2023-01-04 10:17', NULL);
INSERT INTO order_detail VALUES (1083,1001,1,7.89);
INSERT INTO order_detail VALUES (1083,1019,2,6.76);
INSERT INTO order_detail VALUES (1083,1023,3,25.59);
INSERT INTO order_detail VALUES (1083,1024,3,43.98);
INSERT INTO order_detail VALUES (1083,1012,4,13.67);
UPDATE order_header SET total = 284.8 WHERE order_id = 1083;
INSERT INTO order_header VALUES (1084,99,'2023-04-26 03:11', NULL);
INSERT INTO order_detail VALUES (1084,1010,2,5.48);
INSERT INTO order_detail VALUES (1084,1023,3,26.98);
INSERT INTO order_detail VALUES (1084,1022,1,34.78);
UPDATE order_header SET total = 126.68 WHERE order_id = 1084;
INSERT INTO order_header VALUES (1085,127,'2023-01-22 07:37', NULL);
INSERT INTO order_detail VALUES (1085,1018,1,3.33);
INSERT INTO order_detail VALUES (1085,1023,2,26.98);
UPDATE order_header SET total = 57.29 WHERE order_id = 1085;
INSERT INTO order_header VALUES (1086,101,'2023-07-23 13:30', NULL);
INSERT INTO order_detail VALUES (1086,1012,1,11.84);
UPDATE order_header SET total = 11.84 WHERE order_id = 1086;
INSERT INTO order_header VALUES (1087,19,'2023-06-24 01:17', NULL);
INSERT INTO order_detail VALUES (1087,1003,4,9.79);
INSERT INTO order_detail VALUES (1087,1011,4,16.93);
INSERT INTO order_detail VALUES (1087,1020,2,18.78);
INSERT INTO order_detail VALUES (1087,1023,1,25.36);
INSERT INTO order_detail VALUES (1087,1018,2,3.33);
UPDATE order_header SET total = 176.46 WHERE order_id = 1087;
INSERT INTO order_header VALUES (1088,50,'2023-07-04 05:36', NULL);
INSERT INTO order_detail VALUES (1088,1001,4,6.27);
UPDATE order_header SET total = 25.08 WHERE order_id = 1088;
INSERT INTO order_header VALUES (1089,80,'2023-02-17 14:55', NULL);
INSERT INTO order_detail VALUES (1089,1002,4,6.98);
INSERT INTO order_detail VALUES (1089,1011,3,7.02);
INSERT INTO order_detail VALUES (1089,1023,4,24.28);
INSERT INTO order_detail VALUES (1089,1020,1,22.95);
INSERT INTO order_detail VALUES (1089,1019,4,6.67);
UPDATE order_header SET total = 195.73 WHERE order_id = 1089;
INSERT INTO order_header VALUES (1090,35,'2023-08-23 15:31', NULL);
INSERT INTO order_detail VALUES (1090,1022,3,42.56);
UPDATE order_header SET total = 127.68 WHERE order_id = 1090;
INSERT INTO order_header VALUES (1091,35,'2023-09-03 02:35', NULL);
INSERT INTO order_detail VALUES (1091,1010,2,4.67);
INSERT INTO order_detail VALUES (1091,1022,2,34.78);
INSERT INTO order_detail VALUES (1091,1024,1,43.98);
UPDATE order_header SET total = 122.88 WHERE order_id = 1091;
INSERT INTO order_header VALUES (1092,69,'2023-12-29 19:00', NULL);
INSERT INTO order_detail VALUES (1092,1018,4,3.33);
INSERT INTO order_detail VALUES (1092,1010,1,4.9);
UPDATE order_header SET total = 18.22 WHERE order_id = 1092;
INSERT INTO order_header VALUES (1093,84,'2023-07-25 19:17', NULL);
INSERT INTO order_detail VALUES (1093,1010,3,4.93);
INSERT INTO order_detail VALUES (1093,1002,4,7.89);
INSERT INTO order_detail VALUES (1093,1020,3,18.78);
INSERT INTO order_detail VALUES (1093,1023,4,21.57);
INSERT INTO order_detail VALUES (1093,1022,2,34.78);
UPDATE order_header SET total = 258.53 WHERE order_id = 1093;
INSERT INTO order_header VALUES (1094,76,'2023-10-13 19:47', NULL);
INSERT INTO order_detail VALUES (1094,1020,4,17.99);
INSERT INTO order_detail VALUES (1094,1010,1,5.7);
INSERT INTO order_detail VALUES (1094,1003,2,8.28);
INSERT INTO order_detail VALUES (1094,1002,2,7.89);
INSERT INTO order_detail VALUES (1094,1022,3,33.7);
UPDATE order_header SET total = 211.1 WHERE order_id = 1094;
INSERT INTO order_header VALUES (1095,99,'2023-08-20 14:33', NULL);
INSERT INTO order_detail VALUES (1095,1002,2,7.6);
INSERT INTO order_detail VALUES (1095,1011,4,15.22);
INSERT INTO order_detail VALUES (1095,1003,2,9.69);
UPDATE order_header SET total = 95.46 WHERE order_id = 1095;
INSERT INTO order_header VALUES (1096,60,'2023-01-15 06:33', NULL);
INSERT INTO order_detail VALUES (1096,1003,1,8.98);
INSERT INTO order_detail VALUES (1096,1020,2,15.94);
INSERT INTO order_detail VALUES (1096,1022,1,41.09);
INSERT INTO order_detail VALUES (1096,1001,3,7.89);
INSERT INTO order_detail VALUES (1096,1011,4,15.98);
INSERT INTO order_detail VALUES (1096,1012,3,13.38);
UPDATE order_header SET total = 209.68 WHERE order_id = 1096;
INSERT INTO order_header VALUES (1097,32,'2023-12-11 23:00', NULL);
INSERT INTO order_detail VALUES (1097,1011,3,3.67);
INSERT INTO order_detail VALUES (1097,1001,4,6.46);
INSERT INTO order_detail VALUES (1097,1012,4,13.58);
INSERT INTO order_detail VALUES (1097,1002,2,7.89);
INSERT INTO order_detail VALUES (1097,1024,4,37.1);
INSERT INTO order_detail VALUES (1097,1003,4,8.98);
UPDATE order_header SET total = 291.27 WHERE order_id = 1097;
INSERT INTO order_header VALUES (1098,120,'2023-07-03 23:40', NULL);
INSERT INTO order_detail VALUES (1098,1011,4,3.79);
UPDATE order_header SET total = 15.16 WHERE order_id = 1098;
INSERT INTO order_header VALUES (1099,111,'2024-01-25 11:34', NULL);
INSERT INTO order_detail VALUES (1099,1010,1,4.77);
INSERT INTO order_detail VALUES (1099,1012,3,13.67);
UPDATE order_header SET total = 45.78 WHERE order_id = 1099;
INSERT INTO order_header VALUES (1100,106,'2023-01-22 10:56', NULL);
INSERT INTO order_detail VALUES (1100,1019,4,6.67);
INSERT INTO order_detail VALUES (1100,1023,1,26.98);
INSERT INTO order_detail VALUES (1100,1011,2,4.11);
INSERT INTO order_detail VALUES (1100,1024,3,43.98);
INSERT INTO order_detail VALUES (1100,1018,4,2.73);
INSERT INTO order_detail VALUES (1100,1010,2,4.67);
UPDATE order_header SET total = 214.08 WHERE order_id = 1100;
INSERT INTO order_header VALUES (1101,113,'2023-01-31 18:28', NULL);
INSERT INTO order_detail VALUES (1101,1019,1,7.5);
INSERT INTO order_detail VALUES (1101,1023,4,26.98);
INSERT INTO order_detail VALUES (1101,1024,3,43.98);
INSERT INTO order_detail VALUES (1101,1003,2,8.98);
INSERT INTO order_detail VALUES (1101,1011,2,17.67);
UPDATE order_header SET total = 300.66 WHERE order_id = 1101;
INSERT INTO order_header VALUES (1102,116,'2023-05-07 03:34', NULL);
INSERT INTO order_detail VALUES (1102,1002,3,7.84);
INSERT INTO order_detail VALUES (1102,1018,1,3.33);
INSERT INTO order_detail VALUES (1102,1023,1,26.98);
INSERT INTO order_detail VALUES (1102,1020,4,18.78);
INSERT INTO order_detail VALUES (1102,1019,3,6.67);
INSERT INTO order_detail VALUES (1102,1012,4,13.19);
UPDATE order_header SET total = 201.72 WHERE order_id = 1102;
INSERT INTO order_header VALUES (1103,37,'2023-09-11 21:22', NULL);
INSERT INTO order_detail VALUES (1103,1024,1,51.84);
INSERT INTO order_detail VALUES (1103,1018,4,4.15);
INSERT INTO order_detail VALUES (1103,1020,4,20.55);
UPDATE order_header SET total = 150.64 WHERE order_id = 1103;
INSERT INTO order_header VALUES (1104,26,'2023-11-29 20:44', NULL);
INSERT INTO order_detail VALUES (1104,1011,2,2.92);
INSERT INTO order_detail VALUES (1104,1003,1,8.88);
INSERT INTO order_detail VALUES (1104,1023,2,26.98);
UPDATE order_header SET total = 68.68 WHERE order_id = 1104;
INSERT INTO order_header VALUES (1105,76,'2023-12-15 13:48', NULL);
INSERT INTO order_detail VALUES (1105,1010,1,5.56);
INSERT INTO order_detail VALUES (1105,1022,2,40.23);
INSERT INTO order_detail VALUES (1105,1018,2,3.33);
INSERT INTO order_detail VALUES (1105,1019,2,6.88);
UPDATE order_header SET total = 106.44 WHERE order_id = 1105;
INSERT INTO order_header VALUES (1106,88,'2023-11-29 02:13', NULL);
INSERT INTO order_detail VALUES (1106,1020,4,18.12);
INSERT INTO order_detail VALUES (1106,1003,2,9.63);
UPDATE order_header SET total = 91.74 WHERE order_id = 1106;
INSERT INTO order_header VALUES (1107,41,'2023-10-11 14:39', NULL);
INSERT INTO order_detail VALUES (1107,1024,3,43.98);
INSERT INTO order_detail VALUES (1107,1001,2,6.36);
INSERT INTO order_detail VALUES (1107,1003,4,15.98);
INSERT INTO order_detail VALUES (1107,1012,1,13.67);
INSERT INTO order_detail VALUES (1107,1022,1,34.78);
UPDATE order_header SET total = 257.03 WHERE order_id = 1107;
INSERT INTO order_header VALUES (1108,129,'2023-06-12 11:44', NULL);
INSERT INTO order_detail VALUES (1108,1001,1,6.07);
INSERT INTO order_detail VALUES (1108,1002,1,7.89);
UPDATE order_header SET total = 13.96 WHERE order_id = 1108;
INSERT INTO order_header VALUES (1109,60,'2023-09-17 00:59', NULL);
INSERT INTO order_detail VALUES (1109,1019,3,8.07);
INSERT INTO order_detail VALUES (1109,1003,2,15.98);
INSERT INTO order_detail VALUES (1109,1022,4,34.78);
UPDATE order_header SET total = 195.29 WHERE order_id = 1109;
INSERT INTO order_header VALUES (1110,107,'2023-11-29 13:36', NULL);
INSERT INTO order_detail VALUES (1110,1022,3,34.78);
INSERT INTO order_detail VALUES (1110,1018,2,3.68);
INSERT INTO order_detail VALUES (1110,1023,1,33.09);
INSERT INTO order_detail VALUES (1110,1012,3,11.12);
INSERT INTO order_detail VALUES (1110,1011,3,3.67);
INSERT INTO order_detail VALUES (1110,1003,1,8.98);
UPDATE order_header SET total = 198.14 WHERE order_id = 1110;
INSERT INTO order_header VALUES (1111,13,'2023-06-21 08:33', NULL);
INSERT INTO order_detail VALUES (1111,1003,3,10.21);
INSERT INTO order_detail VALUES (1111,1010,1,4.69);
INSERT INTO order_detail VALUES (1111,1011,1,15.98);
INSERT INTO order_detail VALUES (1111,1022,1,34.29);
UPDATE order_header SET total = 85.59 WHERE order_id = 1111;
INSERT INTO order_header VALUES (1112,59,'2023-03-18 22:09', NULL);
INSERT INTO order_detail VALUES (1112,1019,1,6.67);
INSERT INTO order_detail VALUES (1112,1020,1,21.64);
UPDATE order_header SET total = 28.31 WHERE order_id = 1112;
INSERT INTO order_header VALUES (1114,79,'2024-01-25 09:42', NULL);
INSERT INTO order_detail VALUES (1114,1002,3,8.01);
INSERT INTO order_detail VALUES (1114,1024,2,54.12);
UPDATE order_header SET total = 132.27 WHERE order_id = 1114;
INSERT INTO order_header VALUES (1115,134,'2023-03-14 21:14', NULL);
INSERT INTO order_detail VALUES (1115,1022,2,34.78);
INSERT INTO order_detail VALUES (1115,1010,4,4.83);
INSERT INTO order_detail VALUES (1115,1023,4,26.98);
INSERT INTO order_detail VALUES (1115,1012,2,12.04);
INSERT INTO order_detail VALUES (1115,1001,3,7.89);
INSERT INTO order_detail VALUES (1115,1019,4,6.67);
UPDATE order_header SET total = 271.23 WHERE order_id = 1115;
INSERT INTO order_header VALUES (1116,104,'2023-06-17 14:27', NULL);
INSERT INTO order_detail VALUES (1116,1011,4,3.5);
INSERT INTO order_detail VALUES (1116,1018,3,3.33);
INSERT INTO order_detail VALUES (1116,1019,2,6.55);
UPDATE order_header SET total = 37.09 WHERE order_id = 1116;
INSERT INTO order_header VALUES (1117,119,'2023-03-03 19:52', NULL);
INSERT INTO order_detail VALUES (1117,1001,3,6.11);
UPDATE order_header SET total = 18.33 WHERE order_id = 1117;
INSERT INTO order_header VALUES (1118,48,'2023-05-14 22:58', NULL);
INSERT INTO order_detail VALUES (1118,1003,1,8.98);
INSERT INTO order_detail VALUES (1118,1024,2,51.1);
UPDATE order_header SET total = 111.18 WHERE order_id = 1118;
INSERT INTO order_header VALUES (1119,57,'2023-12-18 09:37', NULL);
INSERT INTO order_detail VALUES (1119,1010,3,5.7);
INSERT INTO order_detail VALUES (1119,1018,1,3.45);
INSERT INTO order_detail VALUES (1119,1022,4,32.74);
INSERT INTO order_detail VALUES (1119,1023,4,23.13);
INSERT INTO order_detail VALUES (1119,1002,2,7.68);
INSERT INTO order_detail VALUES (1119,1019,2,7.07);
UPDATE order_header SET total = 273.53 WHERE order_id = 1119;
INSERT INTO order_header VALUES (1120,41,'2023-11-28 14:19', NULL);
INSERT INTO order_detail VALUES (1120,1002,1,7.89);
INSERT INTO order_detail VALUES (1120,1024,3,50.17);
INSERT INTO order_detail VALUES (1120,1011,3,3.67);
UPDATE order_header SET total = 169.41 WHERE order_id = 1120;
INSERT INTO order_header VALUES (1121,74,'2023-06-14 12:53', NULL);
INSERT INTO order_detail VALUES (1121,1003,2,15.98);
INSERT INTO order_detail VALUES (1121,1024,1,38.29);
INSERT INTO order_detail VALUES (1121,1020,1,18.78);
INSERT INTO order_detail VALUES (1121,1010,2,4.67);
UPDATE order_header SET total = 98.37 WHERE order_id = 1121;
INSERT INTO order_header VALUES (1123,22,'2023-09-27 00:35', NULL);
INSERT INTO order_detail VALUES (1123,1018,2,3.33);
INSERT INTO order_detail VALUES (1123,1011,3,3.67);
INSERT INTO order_detail VALUES (1123,1010,3,4.67);
INSERT INTO order_detail VALUES (1123,1020,4,18.78);
UPDATE order_header SET total = 106.8 WHERE order_id = 1123;
INSERT INTO order_header VALUES (1124,53,'2023-06-04 19:30', NULL);
INSERT INTO order_detail VALUES (1124,1011,4,4.02);
INSERT INTO order_detail VALUES (1124,1020,2,14.1);
INSERT INTO order_detail VALUES (1124,1018,4,3.33);
UPDATE order_header SET total = 57.6 WHERE order_id = 1124;
INSERT INTO order_header VALUES (1125,108,'2023-10-18 19:30', NULL);
INSERT INTO order_detail VALUES (1125,1023,3,32.18);
UPDATE order_header SET total = 96.54 WHERE order_id = 1125;
INSERT INTO order_header VALUES (1126,21,'2023-12-29 11:15', NULL);
INSERT INTO order_detail VALUES (1126,1011,1,3.56);
INSERT INTO order_detail VALUES (1126,1002,4,7.89);
INSERT INTO order_detail VALUES (1126,1018,4,3.13);
INSERT INTO order_detail VALUES (1126,1022,4,34.42);
INSERT INTO order_detail VALUES (1126,1024,2,34.61);
INSERT INTO order_detail VALUES (1126,1012,1,12.43);
UPDATE order_header SET total = 266.97 WHERE order_id = 1126;
INSERT INTO order_header VALUES (1127,131,'2023-02-23 22:30', NULL);
INSERT INTO order_detail VALUES (1127,1010,4,4.67);
UPDATE order_header SET total = 18.68 WHERE order_id = 1127;
INSERT INTO order_header VALUES (1128,31,'2023-11-07 05:52', NULL);
INSERT INTO order_detail VALUES (1128,1018,3,2.58);
INSERT INTO order_detail VALUES (1128,1019,4,6.21);
INSERT INTO order_detail VALUES (1128,1020,4,21.82);
INSERT INTO order_detail VALUES (1128,1012,4,10.43);
UPDATE order_header SET total = 161.58 WHERE order_id = 1128;
INSERT INTO order_header VALUES (1129,31,'2023-11-23 10:47', NULL);
INSERT INTO order_detail VALUES (1129,1022,2,32.72);
INSERT INTO order_detail VALUES (1129,1011,2,3.24);
INSERT INTO order_detail VALUES (1129,1024,4,51.39);
UPDATE order_header SET total = 277.48 WHERE order_id = 1129;
INSERT INTO order_header VALUES (1130,82,'2023-02-01 17:00', NULL);
INSERT INTO order_detail VALUES (1130,1010,4,4.67);
INSERT INTO order_detail VALUES (1130,1022,4,34.78);
UPDATE order_header SET total = 157.8 WHERE order_id = 1130;
INSERT INTO order_header VALUES (1131,97,'2023-09-01 07:19', NULL);
INSERT INTO order_detail VALUES (1131,1024,2,43.98);
INSERT INTO order_detail VALUES (1131,1019,2,6.67);
INSERT INTO order_detail VALUES (1131,1002,2,7.59);
INSERT INTO order_detail VALUES (1131,1011,4,4.26);
INSERT INTO order_detail VALUES (1131,1020,2,18.78);
UPDATE order_header SET total = 171.08 WHERE order_id = 1131;
INSERT INTO order_header VALUES (1132,43,'2023-06-13 22:51', NULL);
INSERT INTO order_detail VALUES (1132,1010,1,3.85);
INSERT INTO order_detail VALUES (1132,1018,1,3.33);
INSERT INTO order_detail VALUES (1132,1024,1,43.98);
INSERT INTO order_detail VALUES (1132,1011,3,3.67);
INSERT INTO order_detail VALUES (1132,1003,3,8.92);
INSERT INTO order_detail VALUES (1132,1002,4,7.0);
UPDATE order_header SET total = 116.93 WHERE order_id = 1132;
INSERT INTO order_header VALUES (1133,28,'2023-11-13 17:08', NULL);
INSERT INTO order_detail VALUES (1133,1003,1,10.3);
INSERT INTO order_detail VALUES (1133,1024,3,43.8);
INSERT INTO order_detail VALUES (1133,1012,1,13.67);
INSERT INTO order_detail VALUES (1133,1011,2,4.54);
INSERT INTO order_detail VALUES (1133,1001,4,15.98);
UPDATE order_header SET total = 228.37 WHERE order_id = 1133;
INSERT INTO order_header VALUES (1134,51,'2023-05-18 20:23', NULL);
INSERT INTO order_detail VALUES (1134,1001,1,7.92);
INSERT INTO order_detail VALUES (1134,1024,2,15.98);
INSERT INTO order_detail VALUES (1134,1003,1,10.66);
INSERT INTO order_detail VALUES (1134,1012,2,13.67);
INSERT INTO order_detail VALUES (1134,1018,2,2.58);
INSERT INTO order_detail VALUES (1134,1023,3,26.98);
UPDATE order_header SET total = 163.98 WHERE order_id = 1134;
INSERT INTO order_header VALUES (1135,45,'2023-07-08 07:45', NULL);
INSERT INTO order_detail VALUES (1135,1010,3,5.46);
INSERT INTO order_detail VALUES (1135,1024,3,43.98);
INSERT INTO order_detail VALUES (1135,1022,1,32.81);
INSERT INTO order_detail VALUES (1135,1023,2,26.98);
UPDATE order_header SET total = 235.09 WHERE order_id = 1135;
INSERT INTO order_header VALUES (1136,109,'2023-04-20 12:08', NULL);
INSERT INTO order_detail VALUES (1136,1024,1,46.36);
INSERT INTO order_detail VALUES (1136,1022,3,34.78);
UPDATE order_header SET total = 150.7 WHERE order_id = 1136;
INSERT INTO order_header VALUES (1137,100,'2023-11-26 13:16', NULL);
INSERT INTO order_detail VALUES (1137,1022,1,34.78);
INSERT INTO order_detail VALUES (1137,1024,3,43.98);
INSERT INTO order_detail VALUES (1137,1011,3,2.95);
UPDATE order_header SET total = 175.57 WHERE order_id = 1137;
INSERT INTO order_header VALUES (1138,18,'2023-06-22 20:25', NULL);
INSERT INTO order_detail VALUES (1138,1003,3,15.98);
INSERT INTO order_detail VALUES (1138,1020,1,18.78);
INSERT INTO order_detail VALUES (1138,1011,3,3.52);
UPDATE order_header SET total = 77.28 WHERE order_id = 1138;
INSERT INTO order_header VALUES (1139,59,'2024-01-13 14:55', NULL);
INSERT INTO order_detail VALUES (1139,1003,2,15.98);
UPDATE order_header SET total = 31.96 WHERE order_id = 1139;
INSERT INTO order_header VALUES (1140,122,'2023-10-13 04:05', NULL);
INSERT INTO order_detail VALUES (1140,1003,3,10.72);
INSERT INTO order_detail VALUES (1140,1002,3,7.08);
UPDATE order_header SET total = 53.4 WHERE order_id = 1140;
INSERT INTO order_header VALUES (1141,118,'2023-03-02 21:24', NULL);
INSERT INTO order_detail VALUES (1141,1010,4,5.5);
INSERT INTO order_detail VALUES (1141,1019,2,6.67);
INSERT INTO order_detail VALUES (1141,1011,3,3.8);
INSERT INTO order_detail VALUES (1141,1012,4,16.15);
UPDATE order_header SET total = 111.34 WHERE order_id = 1141;
INSERT INTO order_header VALUES (1142,33,'2024-02-03 22:47', NULL);
INSERT INTO order_detail VALUES (1142,1002,4,7.89);
UPDATE order_header SET total = 31.56 WHERE order_id = 1142;
INSERT INTO order_header VALUES (1143,109,'2023-02-15 10:22', NULL);
INSERT INTO order_detail VALUES (1143,1023,3,26.98);
INSERT INTO order_detail VALUES (1143,1012,3,13.67);
UPDATE order_header SET total = 121.95 WHERE order_id = 1143;
INSERT INTO order_header VALUES (1144,77,'2023-04-08 14:11', NULL);
INSERT INTO order_detail VALUES (1144,1002,2,6.1);
UPDATE order_header SET total = 12.2 WHERE order_id = 1144;
INSERT INTO order_header VALUES (1145,131,'2023-05-29 11:24', NULL);
INSERT INTO order_detail VALUES (1145,1003,2,8.98);
INSERT INTO order_detail VALUES (1145,1002,4,6.8);
INSERT INTO order_detail VALUES (1145,1010,2,3.55);
INSERT INTO order_detail VALUES (1145,1022,2,38.45);
UPDATE order_header SET total = 129.16 WHERE order_id = 1145;
INSERT INTO order_header VALUES (1146,111,'2023-01-20 06:55', NULL);
INSERT INTO order_detail VALUES (1146,1002,4,6.41);
INSERT INTO order_detail VALUES (1146,1022,3,28.75);
INSERT INTO order_detail VALUES (1146,1010,1,5.05);
INSERT INTO order_detail VALUES (1146,1003,3,15.98);
UPDATE order_header SET total = 164.88 WHERE order_id = 1146;
INSERT INTO order_header VALUES (1147,99,'2023-03-12 14:21', NULL);
INSERT INTO order_detail VALUES (1147,1019,3,6.67);
INSERT INTO order_detail VALUES (1147,1001,2,7.53);
INSERT INTO order_detail VALUES (1147,1010,2,4.66);
INSERT INTO order_detail VALUES (1147,1023,2,26.98);
UPDATE order_header SET total = 98.35 WHERE order_id = 1147;
INSERT INTO order_header VALUES (1148,71,'2023-06-19 10:22', NULL);
INSERT INTO order_detail VALUES (1148,1018,3,3.33);
INSERT INTO order_detail VALUES (1148,1023,4,26.98);
UPDATE order_header SET total = 117.91 WHERE order_id = 1148;
INSERT INTO order_header VALUES (1149,47,'2023-05-16 00:21', NULL);
INSERT INTO order_detail VALUES (1149,1022,1,34.78);
INSERT INTO order_detail VALUES (1149,1001,1,6.46);
INSERT INTO order_detail VALUES (1149,1020,2,22.48);
INSERT INTO order_detail VALUES (1149,1002,3,7.89);
UPDATE order_header SET total = 109.87 WHERE order_id = 1149;
INSERT INTO order_header VALUES (1150,21,'2023-07-10 00:14', NULL);
INSERT INTO order_detail VALUES (1150,1023,1,30.03);
INSERT INTO order_detail VALUES (1150,1022,2,41.93);
INSERT INTO order_detail VALUES (1150,1018,4,3.33);
UPDATE order_header SET total = 127.21 WHERE order_id = 1150;
INSERT INTO order_header VALUES (1151,96,'2023-08-13 00:32', NULL);
INSERT INTO order_detail VALUES (1151,1024,1,39.9);
INSERT INTO order_detail VALUES (1151,1012,2,13.67);
UPDATE order_header SET total = 67.24 WHERE order_id = 1151;
INSERT INTO order_header VALUES (1152,95,'2023-06-23 17:15', NULL);
INSERT INTO order_detail VALUES (1152,1003,1,8.98);
INSERT INTO order_detail VALUES (1152,1024,2,43.98);
INSERT INTO order_detail VALUES (1152,1001,4,7.89);
INSERT INTO order_detail VALUES (1152,1002,2,7.86);
INSERT INTO order_detail VALUES (1152,1010,2,4.15);
UPDATE order_header SET total = 152.52 WHERE order_id = 1152;
INSERT INTO order_header VALUES (1153,74,'2023-04-25 18:51', NULL);
INSERT INTO order_detail VALUES (1153,1022,3,34.73);
INSERT INTO order_detail VALUES (1153,1001,1,7.54);
INSERT INTO order_detail VALUES (1153,1023,1,15.98);
INSERT INTO order_detail VALUES (1153,1003,3,8.98);
INSERT INTO order_detail VALUES (1153,1024,2,26.98);
UPDATE order_header SET total = 208.61 WHERE order_id = 1153;
INSERT INTO order_header VALUES (1154,68,'2023-06-24 03:58', NULL);
INSERT INTO order_detail VALUES (1154,1001,2,7.32);
INSERT INTO order_detail VALUES (1154,1023,3,26.98);
INSERT INTO order_detail VALUES (1154,1020,3,18.78);
UPDATE order_header SET total = 151.92 WHERE order_id = 1154;
INSERT INTO order_header VALUES (1155,15,'2023-03-26 18:59', NULL);
INSERT INTO order_detail VALUES (1155,1022,3,33.29);
INSERT INTO order_detail VALUES (1155,1012,1,13.67);
INSERT INTO order_detail VALUES (1155,1024,4,45.94);
INSERT INTO order_detail VALUES (1155,1011,2,3.67);
UPDATE order_header SET total = 304.64 WHERE order_id = 1155;
INSERT INTO order_header VALUES (1156,15,'2023-09-29 00:35', NULL);
INSERT INTO order_detail VALUES (1156,1003,3,8.98);
INSERT INTO order_detail VALUES (1156,1011,4,3.87);
INSERT INTO order_detail VALUES (1156,1020,2,23.13);
INSERT INTO order_detail VALUES (1156,1002,3,6.44);
INSERT INTO order_detail VALUES (1156,1012,4,13.67);
INSERT INTO order_detail VALUES (1156,1019,3,6.67);
UPDATE order_header SET total = 182.69 WHERE order_id = 1156;
INSERT INTO order_header VALUES (1157,80,'2023-06-10 08:00', NULL);
INSERT INTO order_detail VALUES (1157,1011,2,3.67);
INSERT INTO order_detail VALUES (1157,1003,3,8.98);
INSERT INTO order_detail VALUES (1157,1024,3,43.98);
INSERT INTO order_detail VALUES (1157,1001,4,7.89);
INSERT INTO order_detail VALUES (1157,1020,3,18.78);
INSERT INTO order_detail VALUES (1157,1019,4,6.67);
UPDATE order_header SET total = 280.8 WHERE order_id = 1157;
INSERT INTO order_header VALUES (1158,76,'2023-02-24 07:01', NULL);
INSERT INTO order_detail VALUES (1158,1019,3,6.81);
UPDATE order_header SET total = 20.43 WHERE order_id = 1158;
INSERT INTO order_header VALUES (1159,55,'2023-08-20 10:04', NULL);
INSERT INTO order_detail VALUES (1159,1012,4,13.67);
UPDATE order_header SET total = 54.68 WHERE order_id = 1159;
INSERT INTO order_header VALUES (1160,134,'2023-12-17 14:34', NULL);
INSERT INTO order_detail VALUES (1160,1010,3,5.8);
INSERT INTO order_detail VALUES (1160,1001,1,6.6);
INSERT INTO order_detail VALUES (1160,1022,1,33.54);
UPDATE order_header SET total = 57.54 WHERE order_id = 1160;
INSERT INTO order_header VALUES (1161,81,'2023-05-16 17:44', NULL);
INSERT INTO order_detail VALUES (1161,1024,3,45.58);
INSERT INTO order_detail VALUES (1161,1011,3,4.05);
UPDATE order_header SET total = 148.89 WHERE order_id = 1161;
INSERT INTO order_header VALUES (1162,77,'2023-04-23 03:28', NULL);
INSERT INTO order_detail VALUES (1162,1003,3,13.73);
INSERT INTO order_detail VALUES (1162,1023,4,26.98);
UPDATE order_header SET total = 149.11 WHERE order_id = 1162;
INSERT INTO order_header VALUES (1163,115,'2024-01-21 12:16', NULL);
INSERT INTO order_detail VALUES (1163,1001,4,7.89);
INSERT INTO order_detail VALUES (1163,1019,1,6.8);
INSERT INTO order_detail VALUES (1163,1003,3,9.06);
INSERT INTO order_detail VALUES (1163,1011,3,3.67);
INSERT INTO order_detail VALUES (1163,1024,4,39.5);
INSERT INTO order_detail VALUES (1163,1002,2,6.24);
UPDATE order_header SET total = 247.03 WHERE order_id = 1163;
INSERT INTO order_header VALUES (1164,22,'2023-03-27 05:51', NULL);
INSERT INTO order_detail VALUES (1164,1003,1,8.98);
INSERT INTO order_detail VALUES (1164,1010,2,5.18);
INSERT INTO order_detail VALUES (1164,1024,1,34.18);
INSERT INTO order_detail VALUES (1164,1023,3,26.98);
INSERT INTO order_detail VALUES (1164,1012,2,13.67);
UPDATE order_header SET total = 161.8 WHERE order_id = 1164;
INSERT INTO order_header VALUES (1165,62,'2023-07-18 18:37', NULL);
INSERT INTO order_detail VALUES (1165,1010,1,4.67);
INSERT INTO order_detail VALUES (1165,1023,1,27.02);
INSERT INTO order_detail VALUES (1165,1024,3,43.98);
INSERT INTO order_detail VALUES (1165,1003,3,15.98);
UPDATE order_header SET total = 211.57 WHERE order_id = 1165;
INSERT INTO order_header VALUES (1166,46,'2024-01-27 01:20', NULL);
INSERT INTO order_detail VALUES (1166,1002,2,9.42);
INSERT INTO order_detail VALUES (1166,1018,3,3.33);
INSERT INTO order_detail VALUES (1166,1003,1,8.98);
INSERT INTO order_detail VALUES (1166,1011,2,12.03);
UPDATE order_header SET total = 61.87 WHERE order_id = 1166;
INSERT INTO order_header VALUES (1167,86,'2023-07-21 23:29', NULL);
INSERT INTO order_detail VALUES (1167,1012,2,13.67);
INSERT INTO order_detail VALUES (1167,1003,3,7.55);
INSERT INTO order_detail VALUES (1167,1002,1,7.89);
INSERT INTO order_detail VALUES (1167,1022,4,34.78);
INSERT INTO order_detail VALUES (1167,1001,1,6.18);
UPDATE order_header SET total = 203.18 WHERE order_id = 1167;
INSERT INTO order_header VALUES (1168,22,'2023-04-12 21:36', NULL);
INSERT INTO order_detail VALUES (1168,1020,4,19.87);
INSERT INTO order_detail VALUES (1168,1003,3,8.98);
INSERT INTO order_detail VALUES (1168,1018,2,3.33);
INSERT INTO order_detail VALUES (1168,1024,3,43.98);
INSERT INTO order_detail VALUES (1168,1001,4,7.15);
INSERT INTO order_detail VALUES (1168,1023,2,26.98);
UPDATE order_header SET total = 327.58 WHERE order_id = 1168;
INSERT INTO order_header VALUES (1169,92,'2023-08-12 10:57', NULL);
INSERT INTO order_detail VALUES (1169,1003,2,8.98);
INSERT INTO order_detail VALUES (1169,1020,1,18.78);
INSERT INTO order_detail VALUES (1169,1001,2,7.89);
UPDATE order_header SET total = 52.52 WHERE order_id = 1169;
INSERT INTO order_header VALUES (1170,35,'2023-05-15 06:01', NULL);
INSERT INTO order_detail VALUES (1170,1023,1,26.98);
INSERT INTO order_detail VALUES (1170,1002,4,7.89);
INSERT INTO order_detail VALUES (1170,1001,2,6.8);
INSERT INTO order_detail VALUES (1170,1012,3,13.68);
INSERT INTO order_detail VALUES (1170,1010,1,4.68);
INSERT INTO order_detail VALUES (1170,1011,2,3.67);
UPDATE order_header SET total = 125.2 WHERE order_id = 1170;
INSERT INTO order_header VALUES (1171,113,'2023-11-11 12:13', NULL);
INSERT INTO order_detail VALUES (1171,1003,2,8.98);
INSERT INTO order_detail VALUES (1171,1023,2,25.22);
INSERT INTO order_detail VALUES (1171,1011,1,3.67);
INSERT INTO order_detail VALUES (1171,1012,3,16.53);
INSERT INTO order_detail VALUES (1171,1002,1,8.48);
INSERT INTO order_detail VALUES (1171,1024,1,43.98);
UPDATE order_header SET total = 174.12 WHERE order_id = 1171;
INSERT INTO order_header VALUES (1172,76,'2023-11-21 14:15', NULL);
INSERT INTO order_detail VALUES (1172,1020,4,18.78);
INSERT INTO order_detail VALUES (1172,1023,2,26.98);
INSERT INTO order_detail VALUES (1172,1001,3,7.89);
UPDATE order_header SET total = 152.75 WHERE order_id = 1172;
INSERT INTO order_header VALUES (1173,54,'2023-09-07 09:29', NULL);
INSERT INTO order_detail VALUES (1173,1024,2,46.22);
INSERT INTO order_detail VALUES (1173,1001,1,8.98);
INSERT INTO order_detail VALUES (1173,1012,4,13.67);
INSERT INTO order_detail VALUES (1173,1003,1,15.81);
UPDATE order_header SET total = 171.91 WHERE order_id = 1173;
INSERT INTO order_header VALUES (1174,36,'2023-10-30 18:28', NULL);
INSERT INTO order_detail VALUES (1174,1001,2,6.94);
INSERT INTO order_detail VALUES (1174,1010,2,4.67);
UPDATE order_header SET total = 23.22 WHERE order_id = 1174;
INSERT INTO order_header VALUES (1175,61,'2023-11-03 01:23', NULL);
INSERT INTO order_detail VALUES (1175,1018,4,3.33);
INSERT INTO order_detail VALUES (1175,1022,2,34.78);
INSERT INTO order_detail VALUES (1175,1023,3,29.48);
INSERT INTO order_detail VALUES (1175,1020,4,18.78);
INSERT INTO order_detail VALUES (1175,1019,1,6.29);
UPDATE order_header SET total = 252.73 WHERE order_id = 1175;
INSERT INTO order_header VALUES (1176,23,'2023-01-09 03:39', NULL);
INSERT INTO order_detail VALUES (1176,1001,1,7.32);
INSERT INTO order_detail VALUES (1176,1003,1,15.98);
UPDATE order_header SET total = 23.3 WHERE order_id = 1176;
INSERT INTO order_header VALUES (1177,109,'2023-12-14 01:07', NULL);
INSERT INTO order_detail VALUES (1177,1022,4,34.38);
INSERT INTO order_detail VALUES (1177,1024,2,43.98);
INSERT INTO order_detail VALUES (1177,1019,1,7.93);
INSERT INTO order_detail VALUES (1177,1001,4,5.94);
INSERT INTO order_detail VALUES (1177,1012,1,13.67);
INSERT INTO order_detail VALUES (1177,1018,1,3.33);
UPDATE order_header SET total = 274.17 WHERE order_id = 1177;
INSERT INTO order_header VALUES (1178,58,'2023-12-02 13:59', NULL);
INSERT INTO order_detail VALUES (1178,1022,3,34.78);
INSERT INTO order_detail VALUES (1178,1010,4,4.67);
UPDATE order_header SET total = 123.02 WHERE order_id = 1178;
INSERT INTO order_header VALUES (1179,62,'2023-10-10 23:15', NULL);
INSERT INTO order_detail VALUES (1179,1022,2,34.78);
INSERT INTO order_detail VALUES (1179,1010,1,4.67);
INSERT INTO order_detail VALUES (1179,1011,4,3.67);
INSERT INTO order_detail VALUES (1179,1003,2,16.05);
INSERT INTO order_detail VALUES (1179,1012,3,13.67);
UPDATE order_header SET total = 162.02 WHERE order_id = 1179;
INSERT INTO order_header VALUES (1180,88,'2023-12-23 03:38', NULL);
INSERT INTO order_detail VALUES (1180,1001,3,6.23);
INSERT INTO order_detail VALUES (1180,1020,1,18.78);
INSERT INTO order_detail VALUES (1180,1002,4,7.89);
INSERT INTO order_detail VALUES (1180,1012,3,13.67);
INSERT INTO order_detail VALUES (1180,1003,1,15.98);
INSERT INTO order_detail VALUES (1180,1023,2,26.98);
UPDATE order_header SET total = 179.98 WHERE order_id = 1180;
INSERT INTO order_header VALUES (1181,66,'2023-01-06 07:20', NULL);
INSERT INTO order_detail VALUES (1181,1023,2,23.96);
INSERT INTO order_detail VALUES (1181,1010,4,4.43);
UPDATE order_header SET total = 65.64 WHERE order_id = 1181;
INSERT INTO order_header VALUES (1182,85,'2023-04-13 14:24', NULL);
INSERT INTO order_detail VALUES (1182,1011,2,3.67);
INSERT INTO order_detail VALUES (1182,1002,2,7.51);
INSERT INTO order_detail VALUES (1182,1012,1,13.04);
INSERT INTO order_detail VALUES (1182,1024,1,43.98);
INSERT INTO order_detail VALUES (1182,1003,3,7.26);
UPDATE order_header SET total = 101.16 WHERE order_id = 1182;
INSERT INTO order_header VALUES (1183,75,'2023-05-12 22:29', NULL);
INSERT INTO order_detail VALUES (1183,1011,1,3.23);
INSERT INTO order_detail VALUES (1183,1018,4,3.33);
INSERT INTO order_detail VALUES (1183,1010,2,4.67);
INSERT INTO order_detail VALUES (1183,1024,2,43.98);
INSERT INTO order_detail VALUES (1183,1012,4,13.67);
UPDATE order_header SET total = 168.53 WHERE order_id = 1183;
INSERT INTO order_header VALUES (1184,76,'2023-10-02 12:48', NULL);
INSERT INTO order_detail VALUES (1184,1020,4,16.14);
UPDATE order_header SET total = 64.56 WHERE order_id = 1184;
INSERT INTO order_header VALUES (1185,83,'2023-05-18 14:32', NULL);
INSERT INTO order_detail VALUES (1185,1023,2,26.98);
INSERT INTO order_detail VALUES (1185,1010,3,3.75);
UPDATE order_header SET total = 65.21 WHERE order_id = 1185;
INSERT INTO order_header VALUES (1186,127,'2023-02-10 10:00', NULL);
INSERT INTO order_detail VALUES (1186,1024,4,49.79);
INSERT INTO order_detail VALUES (1186,1003,3,10.1);
INSERT INTO order_detail VALUES (1186,1010,2,5.37);
INSERT INTO order_detail VALUES (1186,1022,4,34.78);
INSERT INTO order_detail VALUES (1186,1020,1,18.78);
INSERT INTO order_detail VALUES (1186,1002,4,7.89);
UPDATE order_header SET total = 429.66 WHERE order_id = 1186;
INSERT INTO order_header VALUES (1187,109,'2023-03-31 10:20', NULL);
INSERT INTO order_detail VALUES (1187,1020,3,22.18);
INSERT INTO order_detail VALUES (1187,1019,2,6.67);
INSERT INTO order_detail VALUES (1187,1010,2,5.74);
INSERT INTO order_detail VALUES (1187,1022,3,34.76);
UPDATE order_header SET total = 195.64 WHERE order_id = 1187;
INSERT INTO order_header VALUES (1188,36,'2023-08-03 21:47', NULL);
INSERT INTO order_detail VALUES (1188,1010,2,4.67);
INSERT INTO order_detail VALUES (1188,1022,4,40.0);
INSERT INTO order_detail VALUES (1188,1020,2,14.18);
INSERT INTO order_detail VALUES (1188,1003,4,19.94);
INSERT INTO order_detail VALUES (1188,1012,3,13.67);
INSERT INTO order_detail VALUES (1188,1002,3,9.3);
UPDATE order_header SET total = 346.37 WHERE order_id = 1188;
INSERT INTO order_header VALUES (1189,16,'2023-07-23 21:28', NULL);
INSERT INTO order_detail VALUES (1189,1011,3,3.78);
UPDATE order_header SET total = 11.34 WHERE order_id = 1189;
INSERT INTO order_header VALUES (1190,129,'2023-05-12 03:25', NULL);
INSERT INTO order_detail VALUES (1190,1001,4,7.89);
INSERT INTO order_detail VALUES (1190,1010,4,4.67);
INSERT INTO order_detail VALUES (1190,1012,4,13.67);
UPDATE order_header SET total = 104.92 WHERE order_id = 1190;
INSERT INTO order_header VALUES (1191,28,'2023-03-27 11:40', NULL);
INSERT INTO order_detail VALUES (1191,1023,3,26.98);
INSERT INTO order_detail VALUES (1191,1001,4,15.54);
INSERT INTO order_detail VALUES (1191,1018,3,3.33);
INSERT INTO order_detail VALUES (1191,1019,4,5.62);
INSERT INTO order_detail VALUES (1191,1012,1,11.86);
INSERT INTO order_detail VALUES (1191,1003,3,8.98);
UPDATE order_header SET total = 214.37 WHERE order_id = 1191;
INSERT INTO order_header VALUES (1192,99,'2024-01-19 11:08', NULL);
INSERT INTO order_detail VALUES (1192,1024,1,36.4);
UPDATE order_header SET total = 36.4 WHERE order_id = 1192;
INSERT INTO order_header VALUES (1193,93,'2023-07-19 23:17', NULL);
INSERT INTO order_detail VALUES (1193,1018,3,3.33);
INSERT INTO order_detail VALUES (1193,1012,4,13.67);
INSERT INTO order_detail VALUES (1193,1003,3,15.98);
UPDATE order_header SET total = 112.61 WHERE order_id = 1193;
INSERT INTO order_header VALUES (1194,27,'2023-12-24 19:34', NULL);
INSERT INTO order_detail VALUES (1194,1010,3,4.11);
INSERT INTO order_detail VALUES (1194,1020,3,19.0);
INSERT INTO order_detail VALUES (1194,1018,2,3.28);
INSERT INTO order_detail VALUES (1194,1012,1,13.67);
INSERT INTO order_detail VALUES (1194,1023,4,26.98);
UPDATE order_header SET total = 197.48 WHERE order_id = 1194;
INSERT INTO order_header VALUES (1195,71,'2023-06-03 20:39', NULL);
INSERT INTO order_detail VALUES (1195,1024,4,48.71);
UPDATE order_header SET total = 194.84 WHERE order_id = 1195;
INSERT INTO order_header VALUES (1196,92,'2023-07-19 14:41', NULL);
INSERT INTO order_detail VALUES (1196,1012,1,12.23);
INSERT INTO order_detail VALUES (1196,1024,4,43.98);
INSERT INTO order_detail VALUES (1196,1023,3,26.98);
INSERT INTO order_detail VALUES (1196,1002,4,5.99);
UPDATE order_header SET total = 293.05 WHERE order_id = 1196;
INSERT INTO order_header VALUES (1197,16,'2023-10-01 05:01', NULL);
INSERT INTO order_detail VALUES (1197,1019,4,6.4);
UPDATE order_header SET total = 25.6 WHERE order_id = 1197;
INSERT INTO order_header VALUES (1198,110,'2023-09-13 13:55', NULL);
INSERT INTO order_detail VALUES (1198,1020,2,21.99);
INSERT INTO order_detail VALUES (1198,1001,4,7.89);
INSERT INTO order_detail VALUES (1198,1022,1,34.78);
UPDATE order_header SET total = 110.32 WHERE order_id = 1198;
INSERT INTO order_header VALUES (1199,101,'2023-05-08 05:33', NULL);
INSERT INTO order_detail VALUES (1199,1010,3,4.67);
INSERT INTO order_detail VALUES (1199,1022,2,34.78);
INSERT INTO order_detail VALUES (1199,1003,1,15.98);
INSERT INTO order_detail VALUES (1199,1001,1,8.44);
UPDATE order_header SET total = 107.99 WHERE order_id = 1199;
INSERT INTO order_header VALUES (1200,35,'2023-07-04 16:57', NULL);
INSERT INTO order_detail VALUES (1200,1011,1,3.67);
UPDATE order_header SET total = 3.67 WHERE order_id = 1200;
INSERT INTO order_header VALUES (1201,84,'2023-12-20 00:17', NULL);
INSERT INTO order_detail VALUES (1201,1010,1,3.86);
INSERT INTO order_detail VALUES (1201,1003,1,13.84);
INSERT INTO order_detail VALUES (1201,1018,3,3.33);
INSERT INTO order_detail VALUES (1201,1022,4,34.78);
UPDATE order_header SET total = 166.81 WHERE order_id = 1201;
INSERT INTO order_header VALUES (1202,73,'2023-12-19 07:44', NULL);
INSERT INTO order_detail VALUES (1202,1020,2,18.78);
INSERT INTO order_detail VALUES (1202,1003,3,15.73);
INSERT INTO order_detail VALUES (1202,1023,2,22.33);
INSERT INTO order_detail VALUES (1202,1024,3,43.98);
UPDATE order_header SET total = 261.35 WHERE order_id = 1202;
INSERT INTO order_header VALUES (1203,79,'2023-07-07 06:55', NULL);
INSERT INTO order_detail VALUES (1203,1022,4,37.97);
INSERT INTO order_detail VALUES (1203,1019,2,6.67);
INSERT INTO order_detail VALUES (1203,1024,3,40.07);
INSERT INTO order_detail VALUES (1203,1003,1,15.98);
UPDATE order_header SET total = 301.41 WHERE order_id = 1203;
INSERT INTO order_header VALUES (1204,18,'2023-01-23 08:52', NULL);
INSERT INTO order_detail VALUES (1204,1002,3,6.79);
INSERT INTO order_detail VALUES (1204,1001,1,9.55);
UPDATE order_header SET total = 29.92 WHERE order_id = 1204;
INSERT INTO order_header VALUES (1205,93,'2023-09-09 13:47', NULL);
INSERT INTO order_detail VALUES (1205,1001,1,7.89);
UPDATE order_header SET total = 7.89 WHERE order_id = 1205;
INSERT INTO order_header VALUES (1206,19,'2023-04-21 22:44', NULL);
INSERT INTO order_detail VALUES (1206,1001,1,7.89);
INSERT INTO order_detail VALUES (1206,1018,3,3.33);
INSERT INTO order_detail VALUES (1206,1023,4,26.98);
INSERT INTO order_detail VALUES (1206,1020,2,18.78);
INSERT INTO order_detail VALUES (1206,1003,4,8.98);
UPDATE order_header SET total = 199.28 WHERE order_id = 1206;
INSERT INTO order_header VALUES (1207,94,'2023-03-22 19:33', NULL);
INSERT INTO order_detail VALUES (1207,1001,2,7.89);
INSERT INTO order_detail VALUES (1207,1018,2,3.41);
INSERT INTO order_detail VALUES (1207,1010,3,4.56);
INSERT INTO order_detail VALUES (1207,1003,4,6.89);
INSERT INTO order_detail VALUES (1207,1020,3,18.78);
UPDATE order_header SET total = 120.18 WHERE order_id = 1207;
INSERT INTO order_header VALUES (1208,76,'2023-03-11 06:31', NULL);
INSERT INTO order_detail VALUES (1208,1019,4,5.46);
INSERT INTO order_detail VALUES (1208,1002,3,7.89);
INSERT INTO order_detail VALUES (1208,1011,2,4.24);
UPDATE order_header SET total = 53.99 WHERE order_id = 1208;
INSERT INTO order_header VALUES (1209,21,'2023-10-20 11:20', NULL);
INSERT INTO order_detail VALUES (1209,1001,1,15.98);
INSERT INTO order_detail VALUES (1209,1003,4,6.99);
INSERT INTO order_detail VALUES (1209,1023,3,31.26);
INSERT INTO order_detail VALUES (1209,1019,4,6.67);
UPDATE order_header SET total = 164.4 WHERE order_id = 1209;
INSERT INTO order_header VALUES (1210,25,'2024-01-30 07:12', NULL);
INSERT INTO order_detail VALUES (1210,1003,3,8.98);
INSERT INTO order_detail VALUES (1210,1001,2,8.57);
UPDATE order_header SET total = 44.08 WHERE order_id = 1210;
INSERT INTO order_header VALUES (1211,60,'2023-08-17 02:13', NULL);
INSERT INTO order_detail VALUES (1211,1019,4,6.67);
INSERT INTO order_detail VALUES (1211,1003,1,8.98);
INSERT INTO order_detail VALUES (1211,1010,3,4.67);
INSERT INTO order_detail VALUES (1211,1022,2,34.78);
INSERT INTO order_detail VALUES (1211,1024,4,43.98);
UPDATE order_header SET total = 295.15 WHERE order_id = 1211;
INSERT INTO order_header VALUES (1212,72,'2023-07-22 16:05', NULL);
INSERT INTO order_detail VALUES (1212,1024,1,43.98);
INSERT INTO order_detail VALUES (1212,1018,4,2.81);
INSERT INTO order_detail VALUES (1212,1002,3,7.89);
INSERT INTO order_detail VALUES (1212,1011,1,3.67);
INSERT INTO order_detail VALUES (1212,1010,2,4.67);
INSERT INTO order_detail VALUES (1212,1019,4,6.67);
UPDATE order_header SET total = 118.58 WHERE order_id = 1212;
INSERT INTO order_header VALUES (1213,66,'2023-01-23 04:18', NULL);
INSERT INTO order_detail VALUES (1213,1001,3,15.98);
INSERT INTO order_detail VALUES (1213,1003,1,8.85);
UPDATE order_header SET total = 56.79 WHERE order_id = 1213;
INSERT INTO order_header VALUES (1214,52,'2023-04-18 09:53', NULL);
INSERT INTO order_detail VALUES (1214,1024,4,43.98);
INSERT INTO order_detail VALUES (1214,1003,1,12.47);
INSERT INTO order_detail VALUES (1214,1012,2,13.67);
INSERT INTO order_detail VALUES (1214,1001,3,9.67);
INSERT INTO order_detail VALUES (1214,1022,1,37.57);
INSERT INTO order_detail VALUES (1214,1019,3,6.67);
UPDATE order_header SET total = 302.32 WHERE order_id = 1214;
INSERT INTO order_header VALUES (1215,55,'2023-05-30 21:27', NULL);
INSERT INTO order_detail VALUES (1215,1011,4,3.67);
INSERT INTO order_detail VALUES (1215,1012,1,16.56);
INSERT INTO order_detail VALUES (1215,1023,3,25.54);
INSERT INTO order_detail VALUES (1215,1024,2,48.03);
INSERT INTO order_detail VALUES (1215,1020,3,18.78);
INSERT INTO order_detail VALUES (1215,1022,2,34.78);
UPDATE order_header SET total = 329.82 WHERE order_id = 1215;
INSERT INTO order_header VALUES (1217,126,'2023-11-06 08:42', NULL);
INSERT INTO order_detail VALUES (1217,1012,2,14.06);
INSERT INTO order_detail VALUES (1217,1019,1,7.8);
INSERT INTO order_detail VALUES (1217,1001,2,7.89);
UPDATE order_header SET total = 51.7 WHERE order_id = 1217;
INSERT INTO order_header VALUES (1218,107,'2023-06-13 13:39', NULL);
INSERT INTO order_detail VALUES (1218,1024,2,43.98);
INSERT INTO order_detail VALUES (1218,1001,2,15.98);
INSERT INTO order_detail VALUES (1218,1018,3,3.8);
INSERT INTO order_detail VALUES (1218,1003,2,8.98);
UPDATE order_header SET total = 149.28 WHERE order_id = 1218;
INSERT INTO order_header VALUES (1219,87,'2023-08-29 13:01', NULL);
INSERT INTO order_detail VALUES (1219,1002,1,7.89);
INSERT INTO order_detail VALUES (1219,1003,4,9.75);
INSERT INTO order_detail VALUES (1219,1024,2,43.98);
INSERT INTO order_detail VALUES (1219,1022,1,42.69);
INSERT INTO order_detail VALUES (1219,1011,4,3.67);
INSERT INTO order_detail VALUES (1219,1010,4,4.67);
UPDATE order_header SET total = 210.9 WHERE order_id = 1219;
INSERT INTO order_header VALUES (1220,120,'2023-08-23 15:58', NULL);
INSERT INTO order_detail VALUES (1220,1003,4,10.68);
INSERT INTO order_detail VALUES (1220,1023,2,26.98);
UPDATE order_header SET total = 96.68 WHERE order_id = 1220;
INSERT INTO order_header VALUES (1221,60,'2024-01-12 08:38', NULL);
INSERT INTO order_detail VALUES (1221,1011,4,4.44);
UPDATE order_header SET total = 17.76 WHERE order_id = 1221;
INSERT INTO order_header VALUES (1222,98,'2023-09-22 23:18', NULL);
INSERT INTO order_detail VALUES (1222,1011,3,3.08);
INSERT INTO order_detail VALUES (1222,1023,2,26.98);
UPDATE order_header SET total = 63.2 WHERE order_id = 1222;
INSERT INTO order_header VALUES (1223,21,'2023-05-09 02:30', NULL);
INSERT INTO order_detail VALUES (1223,1022,2,32.7);
INSERT INTO order_detail VALUES (1223,1003,2,8.98);
INSERT INTO order_detail VALUES (1223,1020,2,15.44);
UPDATE order_header SET total = 114.24 WHERE order_id = 1223;
INSERT INTO order_header VALUES (1224,108,'2023-12-31 20:56', NULL);
INSERT INTO order_detail VALUES (1224,1011,1,4.32);
UPDATE order_header SET total = 4.32 WHERE order_id = 1224;
INSERT INTO order_header VALUES (1225,79,'2023-01-03 20:29', NULL);
INSERT INTO order_detail VALUES (1225,1023,2,22.23);
INSERT INTO order_detail VALUES (1225,1012,3,16.09);
INSERT INTO order_detail VALUES (1225,1003,3,7.13);
INSERT INTO order_detail VALUES (1225,1002,1,6.62);
INSERT INTO order_detail VALUES (1225,1011,3,3.67);
UPDATE order_header SET total = 131.75 WHERE order_id = 1225;
INSERT INTO order_header VALUES (1226,98,'2023-12-25 12:20', NULL);
INSERT INTO order_detail VALUES (1226,1002,4,7.89);
INSERT INTO order_detail VALUES (1226,1019,1,5.45);
INSERT INTO order_detail VALUES (1226,1012,3,13.08);
INSERT INTO order_detail VALUES (1226,1011,2,3.67);
INSERT INTO order_detail VALUES (1226,1003,1,17.82);
UPDATE order_header SET total = 101.41 WHERE order_id = 1226;
INSERT INTO order_header VALUES (1227,90,'2023-09-28 16:25', NULL);
INSERT INTO order_detail VALUES (1227,1011,4,3.08);
UPDATE order_header SET total = 12.32 WHERE order_id = 1227;
INSERT INTO order_header VALUES (1228,88,'2023-04-30 22:08', NULL);
INSERT INTO order_detail VALUES (1228,1002,3,9.1);
INSERT INTO order_detail VALUES (1228,1012,2,11.63);
INSERT INTO order_detail VALUES (1228,1023,3,21.15);
INSERT INTO order_detail VALUES (1228,1024,3,43.98);
INSERT INTO order_detail VALUES (1228,1003,3,15.98);
INSERT INTO order_detail VALUES (1228,1020,1,18.78);
UPDATE order_header SET total = 312.67 WHERE order_id = 1228;
INSERT INTO order_header VALUES (1229,53,'2023-07-22 08:29', NULL);
INSERT INTO order_detail VALUES (1229,1012,4,13.4);
INSERT INTO order_detail VALUES (1229,1001,3,9.13);
INSERT INTO order_detail VALUES (1229,1011,1,3.67);
INSERT INTO order_detail VALUES (1229,1003,3,15.98);
INSERT INTO order_detail VALUES (1229,1010,3,4.67);
INSERT INTO order_detail VALUES (1229,1022,1,38.01);
UPDATE order_header SET total = 184.62 WHERE order_id = 1229;
INSERT INTO order_header VALUES (1230,112,'2023-07-01 02:33', NULL);
INSERT INTO order_detail VALUES (1230,1023,3,26.98);
UPDATE order_header SET total = 80.94 WHERE order_id = 1230;
INSERT INTO order_header VALUES (1231,50,'2023-12-30 21:24', NULL);
INSERT INTO order_detail VALUES (1231,1011,3,3.67);
UPDATE order_header SET total = 11.01 WHERE order_id = 1231;
INSERT INTO order_header VALUES (1232,109,'2023-04-14 18:42', NULL);
INSERT INTO order_detail VALUES (1232,1012,1,13.67);
UPDATE order_header SET total = 13.67 WHERE order_id = 1232;
INSERT INTO order_header VALUES (1233,130,'2023-09-22 14:42', NULL);
INSERT INTO order_detail VALUES (1233,1001,1,8.94);
INSERT INTO order_detail VALUES (1233,1019,3,7.53);
INSERT INTO order_detail VALUES (1233,1003,2,13.52);
INSERT INTO order_detail VALUES (1233,1022,3,34.78);
INSERT INTO order_detail VALUES (1233,1018,4,3.33);
INSERT INTO order_detail VALUES (1233,1024,3,39.0);
UPDATE order_header SET total = 293.23 WHERE order_id = 1233;
INSERT INTO order_header VALUES (1234,11,'2023-11-15 12:22', NULL);
INSERT INTO order_detail VALUES (1234,1012,3,13.67);
INSERT INTO order_detail VALUES (1234,1018,3,3.33);
INSERT INTO order_detail VALUES (1234,1001,1,7.77);
INSERT INTO order_detail VALUES (1234,1002,1,6.13);
INSERT INTO order_detail VALUES (1234,1011,4,4.05);
UPDATE order_header SET total = 81.1 WHERE order_id = 1234;
INSERT INTO order_header VALUES (1235,124,'2023-10-31 17:49', NULL);
INSERT INTO order_detail VALUES (1235,1003,1,15.98);
INSERT INTO order_detail VALUES (1235,1002,4,7.14);
INSERT INTO order_detail VALUES (1235,1024,4,53.82);
INSERT INTO order_detail VALUES (1235,1012,2,13.67);
INSERT INTO order_detail VALUES (1235,1022,3,34.78);
INSERT INTO order_detail VALUES (1235,1018,4,4.02);
UPDATE order_header SET total = 407.58 WHERE order_id = 1235;
INSERT INTO order_header VALUES (1236,52,'2023-06-16 04:57', NULL);
INSERT INTO order_detail VALUES (1236,1003,1,9.94);
INSERT INTO order_detail VALUES (1236,1010,1,5.02);
INSERT INTO order_detail VALUES (1236,1022,3,34.78);
INSERT INTO order_detail VALUES (1236,1024,4,43.98);
UPDATE order_header SET total = 295.22 WHERE order_id = 1236;
INSERT INTO order_header VALUES (1237,40,'2023-11-14 14:39', NULL);
INSERT INTO order_detail VALUES (1237,1001,2,9.74);
INSERT INTO order_detail VALUES (1237,1003,4,16.75);
UPDATE order_header SET total = 86.48 WHERE order_id = 1237;
INSERT INTO order_header VALUES (1238,51,'2023-10-12 08:21', NULL);
INSERT INTO order_detail VALUES (1238,1012,1,11.2);
UPDATE order_header SET total = 11.2 WHERE order_id = 1238;
INSERT INTO order_header VALUES (1239,84,'2024-01-22 01:47', NULL);
INSERT INTO order_detail VALUES (1239,1001,3,10.3);
INSERT INTO order_detail VALUES (1239,1011,3,3.67);
INSERT INTO order_detail VALUES (1239,1019,4,6.67);
INSERT INTO order_detail VALUES (1239,1002,3,7.89);
INSERT INTO order_detail VALUES (1239,1018,1,3.33);
INSERT INTO order_detail VALUES (1239,1003,4,15.98);
UPDATE order_header SET total = 159.51 WHERE order_id = 1239;
INSERT INTO order_header VALUES (1240,119,'2023-05-31 19:27', NULL);
INSERT INTO order_detail VALUES (1240,1018,3,3.33);
UPDATE order_header SET total = 9.99 WHERE order_id = 1240;
INSERT INTO order_header VALUES (1241,61,'2023-07-15 20:55', NULL);
INSERT INTO order_detail VALUES (1241,1019,3,6.67);
INSERT INTO order_detail VALUES (1241,1018,2,2.62);
INSERT INTO order_detail VALUES (1241,1020,1,22.39);
INSERT INTO order_detail VALUES (1241,1003,4,15.98);
UPDATE order_header SET total = 111.56 WHERE order_id = 1241;
INSERT INTO order_header VALUES (1242,27,'2023-02-13 11:51', NULL);
INSERT INTO order_detail VALUES (1242,1019,2,7.02);
INSERT INTO order_detail VALUES (1242,1012,4,13.67);
UPDATE order_header SET total = 68.72 WHERE order_id = 1242;
INSERT INTO order_header VALUES (1243,40,'2023-12-31 21:59', NULL);
INSERT INTO order_detail VALUES (1243,1023,1,30.1);
INSERT INTO order_detail VALUES (1243,1012,3,10.79);
INSERT INTO order_detail VALUES (1243,1024,1,46.85);
INSERT INTO order_detail VALUES (1243,1018,1,3.33);
INSERT INTO order_detail VALUES (1243,1022,3,34.78);
UPDATE order_header SET total = 216.99 WHERE order_id = 1243;
INSERT INTO order_header VALUES (1244,125,'2023-06-25 12:46', NULL);
INSERT INTO order_detail VALUES (1244,1003,3,17.54);
INSERT INTO order_detail VALUES (1244,1020,3,18.78);
INSERT INTO order_detail VALUES (1244,1012,3,13.49);
INSERT INTO order_detail VALUES (1244,1018,2,3.33);
INSERT INTO order_detail VALUES (1244,1024,3,43.98);
UPDATE order_header SET total = 288.03 WHERE order_id = 1244;
INSERT INTO order_header VALUES (1245,89,'2023-01-14 14:59', NULL);
INSERT INTO order_detail VALUES (1245,1001,1,15.98);
INSERT INTO order_detail VALUES (1245,1018,2,3.33);
INSERT INTO order_detail VALUES (1245,1003,2,8.98);
UPDATE order_header SET total = 40.6 WHERE order_id = 1245;
INSERT INTO order_header VALUES (1246,57,'2023-03-31 20:53', NULL);
INSERT INTO order_detail VALUES (1246,1011,4,3.56);
INSERT INTO order_detail VALUES (1246,1019,2,7.45);
INSERT INTO order_detail VALUES (1246,1012,3,12.06);
UPDATE order_header SET total = 65.32 WHERE order_id = 1246;
INSERT INTO order_header VALUES (1247,114,'2023-03-01 21:56', NULL);
INSERT INTO order_detail VALUES (1247,1011,4,3.73);
UPDATE order_header SET total = 14.92 WHERE order_id = 1247;
INSERT INTO order_header VALUES (1248,65,'2023-01-07 21:36', NULL);
INSERT INTO order_detail VALUES (1248,1023,3,31.06);
INSERT INTO order_detail VALUES (1248,1022,3,34.78);
INSERT INTO order_detail VALUES (1248,1020,4,20.43);
UPDATE order_header SET total = 279.24 WHERE order_id = 1248;
INSERT INTO order_header VALUES (1249,40,'2024-01-11 06:57', NULL);
INSERT INTO order_detail VALUES (1249,1010,1,4.67);
INSERT INTO order_detail VALUES (1249,1022,4,38.7);
INSERT INTO order_detail VALUES (1249,1024,3,33.51);
INSERT INTO order_detail VALUES (1249,1003,1,16.73);
INSERT INTO order_detail VALUES (1249,1011,2,3.67);
INSERT INTO order_detail VALUES (1249,1023,1,26.98);
UPDATE order_header SET total = 311.05 WHERE order_id = 1249;
INSERT INTO order_header VALUES (1250,25,'2023-02-14 02:58', NULL);
INSERT INTO order_detail VALUES (1250,1003,4,15.98);
INSERT INTO order_detail VALUES (1250,1010,3,4.67);
INSERT INTO order_detail VALUES (1250,1001,3,9.0);
INSERT INTO order_detail VALUES (1250,1011,3,3.67);
INSERT INTO order_detail VALUES (1250,1020,4,23.44);
UPDATE order_header SET total = 209.7 WHERE order_id = 1250;
INSERT INTO order_header VALUES (1251,43,'2023-05-16 18:32', NULL);
INSERT INTO order_detail VALUES (1251,1020,2,18.78);
INSERT INTO order_detail VALUES (1251,1003,1,8.98);
UPDATE order_header SET total = 46.54 WHERE order_id = 1251;
INSERT INTO order_header VALUES (1252,101,'2023-05-13 12:58', NULL);
INSERT INTO order_detail VALUES (1252,1018,3,3.05);
UPDATE order_header SET total = 9.15 WHERE order_id = 1252;
INSERT INTO order_header VALUES (1253,60,'2023-10-22 00:07', NULL);
INSERT INTO order_detail VALUES (1253,1019,4,6.79);
UPDATE order_header SET total = 27.16 WHERE order_id = 1253;
INSERT INTO order_header VALUES (1254,55,'2023-06-20 21:04', NULL);
INSERT INTO order_detail VALUES (1254,1020,4,18.78);
INSERT INTO order_detail VALUES (1254,1001,3,15.98);
INSERT INTO order_detail VALUES (1254,1003,1,8.98);
INSERT INTO order_detail VALUES (1254,1010,3,5.57);
INSERT INTO order_detail VALUES (1254,1024,4,43.98);
INSERT INTO order_detail VALUES (1254,1023,2,20.58);
UPDATE order_header SET total = 365.83 WHERE order_id = 1254;
INSERT INTO order_header VALUES (1255,85,'2023-05-03 14:06', NULL);
INSERT INTO order_detail VALUES (1255,1012,4,15.77);
INSERT INTO order_detail VALUES (1255,1010,4,4.67);
INSERT INTO order_detail VALUES (1255,1011,2,3.67);
INSERT INTO order_detail VALUES (1255,1023,2,26.98);
UPDATE order_header SET total = 143.06 WHERE order_id = 1255;
INSERT INTO order_header VALUES (1256,14,'2024-01-12 00:34', NULL);
INSERT INTO order_detail VALUES (1256,1003,3,8.98);
INSERT INTO order_detail VALUES (1256,1011,1,3.07);
UPDATE order_header SET total = 30.01 WHERE order_id = 1256;
INSERT INTO order_header VALUES (1257,85,'2023-02-02 23:25', NULL);
INSERT INTO order_detail VALUES (1257,1003,3,9.81);
UPDATE order_header SET total = 29.43 WHERE order_id = 1257;
INSERT INTO order_header VALUES (1258,79,'2023-03-12 14:19', NULL);
INSERT INTO order_detail VALUES (1258,1003,3,15.98);
INSERT INTO order_detail VALUES (1258,1019,4,6.94);
INSERT INTO order_detail VALUES (1258,1023,2,31.67);
UPDATE order_header SET total = 139.04 WHERE order_id = 1258;
INSERT INTO order_header VALUES (1259,88,'2023-07-12 05:58', NULL);
INSERT INTO order_detail VALUES (1259,1001,2,8.44);
INSERT INTO order_detail VALUES (1259,1020,4,22.89);
UPDATE order_header SET total = 108.44 WHERE order_id = 1259;
INSERT INTO order_header VALUES (1260,88,'2023-12-21 16:29', NULL);
INSERT INTO order_detail VALUES (1260,1018,1,3.33);
UPDATE order_header SET total = 3.33 WHERE order_id = 1260;
INSERT INTO order_header VALUES (1261,120,'2024-01-25 14:40', NULL);
INSERT INTO order_detail VALUES (1261,1019,2,6.67);
INSERT INTO order_detail VALUES (1261,1024,1,40.99);
INSERT INTO order_detail VALUES (1261,1011,2,3.37);
INSERT INTO order_detail VALUES (1261,1003,4,17.9);
INSERT INTO order_detail VALUES (1261,1002,2,6.03);
UPDATE order_header SET total = 144.73 WHERE order_id = 1261;
INSERT INTO order_header VALUES (1262,75,'2023-03-01 01:04', NULL);
INSERT INTO order_detail VALUES (1262,1002,2,8.83);
UPDATE order_header SET total = 17.66 WHERE order_id = 1262;
INSERT INTO order_header VALUES (1263,121,'2023-04-13 07:13', NULL);
INSERT INTO order_detail VALUES (1263,1019,3,7.4);
INSERT INTO order_detail VALUES (1263,1011,3,3.67);
INSERT INTO order_detail VALUES (1263,1023,2,20.67);
INSERT INTO order_detail VALUES (1263,1024,1,35.43);
UPDATE order_header SET total = 109.98 WHERE order_id = 1263;
INSERT INTO order_header VALUES (1264,69,'2023-08-23 23:50', NULL);
INSERT INTO order_detail VALUES (1264,1010,2,4.67);
INSERT INTO order_detail VALUES (1264,1002,4,8.8);
INSERT INTO order_detail VALUES (1264,1020,2,18.16);
INSERT INTO order_detail VALUES (1264,1019,2,6.67);
UPDATE order_header SET total = 94.2 WHERE order_id = 1264;
INSERT INTO order_header VALUES (1265,85,'2023-03-18 17:09', NULL);
INSERT INTO order_detail VALUES (1265,1002,4,6.25);
INSERT INTO order_detail VALUES (1265,1022,1,34.78);
INSERT INTO order_detail VALUES (1265,1020,4,18.78);
INSERT INTO order_detail VALUES (1265,1003,2,13.9);
INSERT INTO order_detail VALUES (1265,1012,1,14.83);
UPDATE order_header SET total = 177.53 WHERE order_id = 1265;
INSERT INTO order_header VALUES (1266,30,'2023-12-27 16:39', NULL);
INSERT INTO order_detail VALUES (1266,1023,1,26.98);
INSERT INTO order_detail VALUES (1266,1020,1,20.57);
INSERT INTO order_detail VALUES (1266,1012,1,15.4);
INSERT INTO order_detail VALUES (1266,1011,2,3.67);
UPDATE order_header SET total = 70.29 WHERE order_id = 1266;
INSERT INTO order_header VALUES (1267,20,'2023-11-14 16:30', NULL);
INSERT INTO order_detail VALUES (1267,1003,2,15.98);
INSERT INTO order_detail VALUES (1267,1002,1,7.89);
INSERT INTO order_detail VALUES (1267,1018,2,3.06);
UPDATE order_header SET total = 45.97 WHERE order_id = 1267;
INSERT INTO order_header VALUES (1268,79,'2023-02-28 08:38', NULL);
INSERT INTO order_detail VALUES (1268,1001,1,8.77);
INSERT INTO order_detail VALUES (1268,1003,1,16.23);
INSERT INTO order_detail VALUES (1268,1002,3,7.37);
INSERT INTO order_detail VALUES (1268,1024,1,52.42);
INSERT INTO order_detail VALUES (1268,1019,1,8.0);
INSERT INTO order_detail VALUES (1268,1011,3,3.67);
UPDATE order_header SET total = 118.54 WHERE order_id = 1268;
INSERT INTO order_header VALUES (1269,19,'2023-02-25 06:36', NULL);
INSERT INTO order_detail VALUES (1269,1010,4,4.54);
INSERT INTO order_detail VALUES (1269,1018,1,2.6);
UPDATE order_header SET total = 20.76 WHERE order_id = 1269;
INSERT INTO order_header VALUES (1270,121,'2023-04-29 08:26', NULL);
INSERT INTO order_detail VALUES (1270,1010,2,4.67);
INSERT INTO order_detail VALUES (1270,1023,3,23.74);
INSERT INTO order_detail VALUES (1270,1018,4,2.98);
INSERT INTO order_detail VALUES (1270,1019,1,5.95);
INSERT INTO order_detail VALUES (1270,1024,2,43.98);
UPDATE order_header SET total = 186.39 WHERE order_id = 1270;
INSERT INTO order_header VALUES (1271,30,'2023-12-31 19:20', NULL);
INSERT INTO order_detail VALUES (1271,1001,3,9.26);
INSERT INTO order_detail VALUES (1271,1002,1,7.89);
INSERT INTO order_detail VALUES (1271,1022,3,33.88);
INSERT INTO order_detail VALUES (1271,1023,2,26.98);
INSERT INTO order_detail VALUES (1271,1003,1,15.98);
UPDATE order_header SET total = 207.25 WHERE order_id = 1271;
INSERT INTO order_header VALUES (1272,61,'2023-09-13 08:34', NULL);
INSERT INTO order_detail VALUES (1272,1003,4,12.88);
INSERT INTO order_detail VALUES (1272,1020,4,18.78);
UPDATE order_header SET total = 126.64 WHERE order_id = 1272;
INSERT INTO order_header VALUES (1273,27,'2023-12-14 03:33', NULL);
INSERT INTO order_detail VALUES (1273,1019,2,6.67);
INSERT INTO order_detail VALUES (1273,1012,3,10.82);
INSERT INTO order_detail VALUES (1273,1001,4,7.89);
INSERT INTO order_detail VALUES (1273,1010,1,4.67);
INSERT INTO order_detail VALUES (1273,1003,4,8.16);
UPDATE order_header SET total = 114.67 WHERE order_id = 1273;
INSERT INTO order_header VALUES (1274,87,'2023-09-19 02:34', NULL);
INSERT INTO order_detail VALUES (1274,1003,3,8.98);
UPDATE order_header SET total = 26.94 WHERE order_id = 1274;
INSERT INTO order_header VALUES (1275,121,'2023-10-15 02:44', NULL);
INSERT INTO order_detail VALUES (1275,1001,2,7.79);
UPDATE order_header SET total = 15.58 WHERE order_id = 1275;
INSERT INTO order_header VALUES (1276,121,'2023-09-26 14:58', NULL);
INSERT INTO order_detail VALUES (1276,1002,2,9.2);
INSERT INTO order_detail VALUES (1276,1003,3,15.98);
INSERT INTO order_detail VALUES (1276,1019,1,6.67);
UPDATE order_header SET total = 73.01 WHERE order_id = 1276;
INSERT INTO order_header VALUES (1277,48,'2023-10-27 18:56', NULL);
INSERT INTO order_detail VALUES (1277,1020,4,22.6);
INSERT INTO order_detail VALUES (1277,1024,2,49.8);
INSERT INTO order_detail VALUES (1277,1023,4,26.98);
UPDATE order_header SET total = 297.92 WHERE order_id = 1277;
INSERT INTO order_header VALUES (1278,18,'2023-11-03 18:01', NULL);
INSERT INTO order_detail VALUES (1278,1023,3,21.02);
INSERT INTO order_detail VALUES (1278,1012,3,14.99);
INSERT INTO order_detail VALUES (1278,1024,3,38.98);
INSERT INTO order_detail VALUES (1278,1020,4,18.78);
INSERT INTO order_detail VALUES (1278,1018,3,2.98);
INSERT INTO order_detail VALUES (1278,1002,1,7.89);
UPDATE order_header SET total = 316.92 WHERE order_id = 1278;
INSERT INTO order_header VALUES (1279,108,'2023-11-18 00:06', NULL);
INSERT INTO order_detail VALUES (1279,1023,1,26.98);
INSERT INTO order_detail VALUES (1279,1022,3,34.78);
UPDATE order_header SET total = 131.32 WHERE order_id = 1279;
INSERT INTO order_header VALUES (1280,11,'2023-03-12 02:02', NULL);
INSERT INTO order_detail VALUES (1280,1018,4,2.62);
INSERT INTO order_detail VALUES (1280,1001,2,7.89);
INSERT INTO order_detail VALUES (1280,1024,4,48.18);
INSERT INTO order_detail VALUES (1280,1019,2,6.67);
INSERT INTO order_detail VALUES (1280,1003,3,14.42);
UPDATE order_header SET total = 275.58 WHERE order_id = 1280;
INSERT INTO order_header VALUES (1281,105,'2023-03-02 23:24', NULL);
INSERT INTO order_detail VALUES (1281,1022,1,34.51);
INSERT INTO order_detail VALUES (1281,1012,4,10.99);
UPDATE order_header SET total = 78.47 WHERE order_id = 1281;
INSERT INTO order_header VALUES (1282,111,'2023-12-04 13:22', NULL);
INSERT INTO order_detail VALUES (1282,1024,2,40.72);
INSERT INTO order_detail VALUES (1282,1023,1,30.3);
INSERT INTO order_detail VALUES (1282,1011,3,3.67);
INSERT INTO order_detail VALUES (1282,1003,3,18.82);
INSERT INTO order_detail VALUES (1282,1001,2,7.89);
UPDATE order_header SET total = 194.99 WHERE order_id = 1282;
INSERT INTO order_header VALUES (1283,18,'2023-02-20 19:36', NULL);
INSERT INTO order_detail VALUES (1283,1011,3,3.67);
INSERT INTO order_detail VALUES (1283,1003,2,11.04);
INSERT INTO order_detail VALUES (1283,1002,2,7.89);
INSERT INTO order_detail VALUES (1283,1020,4,18.91);
INSERT INTO order_detail VALUES (1283,1022,4,43.21);
UPDATE order_header SET total = 297.35 WHERE order_id = 1283;
INSERT INTO order_header VALUES (1284,25,'2023-08-27 16:16', NULL);
INSERT INTO order_detail VALUES (1284,1019,4,6.67);
UPDATE order_header SET total = 26.68 WHERE order_id = 1284;
INSERT INTO order_header VALUES (1285,49,'2023-12-18 18:57', NULL);
INSERT INTO order_detail VALUES (1285,1001,4,15.98);
INSERT INTO order_detail VALUES (1285,1010,4,5.04);
INSERT INTO order_detail VALUES (1285,1024,1,41.67);
INSERT INTO order_detail VALUES (1285,1003,1,8.98);
UPDATE order_header SET total = 134.73 WHERE order_id = 1285;
INSERT INTO order_header VALUES (1286,124,'2023-03-28 12:47', NULL);
INSERT INTO order_detail VALUES (1286,1003,4,17.31);
UPDATE order_header SET total = 69.24 WHERE order_id = 1286;
INSERT INTO order_header VALUES (1287,131,'2023-07-27 06:54', NULL);
INSERT INTO order_detail VALUES (1287,1001,1,6.97);
INSERT INTO order_detail VALUES (1287,1003,1,12.2);
INSERT INTO order_detail VALUES (1287,1012,2,14.89);
INSERT INTO order_detail VALUES (1287,1022,2,36.92);
UPDATE order_header SET total = 122.79 WHERE order_id = 1287;
INSERT INTO order_header VALUES (1288,107,'2023-02-09 05:36', NULL);
INSERT INTO order_detail VALUES (1288,1001,1,8.98);
INSERT INTO order_detail VALUES (1288,1003,1,15.98);
INSERT INTO order_detail VALUES (1288,1010,1,4.24);
INSERT INTO order_detail VALUES (1288,1012,4,10.5);
INSERT INTO order_detail VALUES (1288,1023,2,26.98);
INSERT INTO order_detail VALUES (1288,1018,3,3.33);
UPDATE order_header SET total = 135.15 WHERE order_id = 1288;
INSERT INTO order_header VALUES (1289,31,'2023-09-09 01:11', NULL);
INSERT INTO order_detail VALUES (1289,1002,1,7.87);
INSERT INTO order_detail VALUES (1289,1003,4,8.98);
INSERT INTO order_detail VALUES (1289,1022,3,34.78);
INSERT INTO order_detail VALUES (1289,1012,3,10.44);
UPDATE order_header SET total = 179.45 WHERE order_id = 1289;
INSERT INTO order_header VALUES (1290,15,'2023-03-07 22:04', NULL);
INSERT INTO order_detail VALUES (1290,1011,1,3.67);
INSERT INTO order_detail VALUES (1290,1001,2,14.48);
INSERT INTO order_detail VALUES (1290,1003,1,8.98);
UPDATE order_header SET total = 41.61 WHERE order_id = 1290;
INSERT INTO order_header VALUES (1291,18,'2023-06-06 21:58', NULL);
INSERT INTO order_detail VALUES (1291,1023,4,26.98);
UPDATE order_header SET total = 107.92 WHERE order_id = 1291;
INSERT INTO order_header VALUES (1292,50,'2023-07-13 21:05', NULL);
INSERT INTO order_detail VALUES (1292,1023,2,26.98);
INSERT INTO order_detail VALUES (1292,1022,3,34.78);
INSERT INTO order_detail VALUES (1292,1024,2,51.62);
INSERT INTO order_detail VALUES (1292,1003,1,15.98);
INSERT INTO order_detail VALUES (1292,1001,2,6.11);
UPDATE order_header SET total = 289.74 WHERE order_id = 1292;
INSERT INTO order_header VALUES (1293,83,'2023-07-25 21:23', NULL);
INSERT INTO order_detail VALUES (1293,1003,3,8.98);
INSERT INTO order_detail VALUES (1293,1011,3,3.67);
UPDATE order_header SET total = 37.95 WHERE order_id = 1293;
INSERT INTO order_header VALUES (1294,48,'2023-08-10 10:44', NULL);
INSERT INTO order_detail VALUES (1294,1002,4,9.71);
INSERT INTO order_detail VALUES (1294,1020,4,20.08);
INSERT INTO order_detail VALUES (1294,1003,4,8.98);
INSERT INTO order_detail VALUES (1294,1011,1,3.67);
INSERT INTO order_detail VALUES (1294,1022,3,30.27);
INSERT INTO order_detail VALUES (1294,1018,3,3.33);
UPDATE order_header SET total = 259.55 WHERE order_id = 1294;
INSERT INTO order_header VALUES (1295,62,'2023-06-13 23:42', NULL);
INSERT INTO order_detail VALUES (1295,1010,1,3.57);
UPDATE order_header SET total = 3.57 WHERE order_id = 1295;
INSERT INTO order_header VALUES (1296,112,'2023-06-08 16:54', NULL);
INSERT INTO order_detail VALUES (1296,1003,2,15.98);
INSERT INTO order_detail VALUES (1296,1018,1,3.33);
INSERT INTO order_detail VALUES (1296,1019,4,6.67);
INSERT INTO order_detail VALUES (1296,1011,1,3.67);
UPDATE order_header SET total = 65.64 WHERE order_id = 1296;
INSERT INTO order_header VALUES (1297,20,'2023-06-10 20:29', NULL);
INSERT INTO order_detail VALUES (1297,1011,3,2.92);
INSERT INTO order_detail VALUES (1297,1019,1,6.67);
INSERT INTO order_detail VALUES (1297,1001,3,16.65);
INSERT INTO order_detail VALUES (1297,1003,4,8.98);
INSERT INTO order_detail VALUES (1297,1010,2,4.67);
UPDATE order_header SET total = 110.64 WHERE order_id = 1297;
INSERT INTO order_header VALUES (1298,37,'2023-03-15 22:05', NULL);
INSERT INTO order_detail VALUES (1298,1012,1,13.15);
UPDATE order_header SET total = 13.15 WHERE order_id = 1298;
INSERT INTO order_header VALUES (1299,97,'2023-05-07 17:01', NULL);
INSERT INTO order_detail VALUES (1299,1019,2,6.29);
INSERT INTO order_detail VALUES (1299,1018,3,3.33);
INSERT INTO order_detail VALUES (1299,1003,1,8.98);
UPDATE order_header SET total = 31.55 WHERE order_id = 1299;
INSERT INTO order_header VALUES (1300,40,'2023-08-15 22:35', NULL);
INSERT INTO order_detail VALUES (1300,1003,4,15.98);
INSERT INTO order_detail VALUES (1300,1002,3,7.89);
INSERT INTO order_detail VALUES (1300,1022,4,33.27);
INSERT INTO order_detail VALUES (1300,1011,3,3.67);
UPDATE order_header SET total = 231.68 WHERE order_id = 1300;
INSERT INTO order_header VALUES (1301,122,'2023-02-21 03:41', NULL);
INSERT INTO order_detail VALUES (1301,1011,1,3.67);
INSERT INTO order_detail VALUES (1301,1003,2,15.98);
UPDATE order_header SET total = 35.63 WHERE order_id = 1301;
INSERT INTO order_header VALUES (1302,111,'2023-11-25 14:51', NULL);
INSERT INTO order_detail VALUES (1302,1020,3,22.29);
INSERT INTO order_detail VALUES (1302,1018,2,3.64);
UPDATE order_header SET total = 74.15 WHERE order_id = 1302;
INSERT INTO order_header VALUES (1303,115,'2023-06-17 22:50', NULL);
INSERT INTO order_detail VALUES (1303,1024,1,43.98);
INSERT INTO order_detail VALUES (1303,1001,2,9.28);
INSERT INTO order_detail VALUES (1303,1003,1,15.41);
UPDATE order_header SET total = 77.95 WHERE order_id = 1303;
INSERT INTO order_header VALUES (1304,43,'2023-03-18 12:49', NULL);
INSERT INTO order_detail VALUES (1304,1012,2,13.67);
UPDATE order_header SET total = 27.34 WHERE order_id = 1304;
INSERT INTO order_header VALUES (1305,114,'2024-02-05 19:05', NULL);
INSERT INTO order_detail VALUES (1305,1024,4,50.41);
INSERT INTO order_detail VALUES (1305,1012,1,12.04);
INSERT INTO order_detail VALUES (1305,1023,4,26.98);
UPDATE order_header SET total = 321.6 WHERE order_id = 1305;
INSERT INTO order_header VALUES (1306,57,'2023-10-26 12:35', NULL);
INSERT INTO order_detail VALUES (1306,1022,4,34.78);
INSERT INTO order_detail VALUES (1306,1010,3,4.8);
INSERT INTO order_detail VALUES (1306,1018,1,2.89);
INSERT INTO order_detail VALUES (1306,1002,3,7.89);
INSERT INTO order_detail VALUES (1306,1020,1,18.82);
INSERT INTO order_detail VALUES (1306,1019,4,6.32);
UPDATE order_header SET total = 224.18 WHERE order_id = 1306;
INSERT INTO order_header VALUES (1307,57,'2023-03-09 08:35', NULL);
INSERT INTO order_detail VALUES (1307,1019,2,6.05);
INSERT INTO order_detail VALUES (1307,1003,2,11.11);
INSERT INTO order_detail VALUES (1307,1001,3,7.89);
INSERT INTO order_detail VALUES (1307,1011,4,4.36);
INSERT INTO order_detail VALUES (1307,1010,3,4.67);
UPDATE order_header SET total = 89.44 WHERE order_id = 1307;
INSERT INTO order_header VALUES (1308,65,'2023-03-26 19:33', NULL);
INSERT INTO order_detail VALUES (1308,1011,4,4.05);
INSERT INTO order_detail VALUES (1308,1018,4,3.99);
INSERT INTO order_detail VALUES (1308,1010,4,4.33);
UPDATE order_header SET total = 49.48 WHERE order_id = 1308;
INSERT INTO order_header VALUES (1309,100,'2023-10-15 14:18', NULL);
INSERT INTO order_detail VALUES (1309,1020,2,18.78);
INSERT INTO order_detail VALUES (1309,1002,1,7.89);
INSERT INTO order_detail VALUES (1309,1003,2,7.08);
INSERT INTO order_detail VALUES (1309,1023,4,26.98);
UPDATE order_header SET total = 167.53 WHERE order_id = 1309;
INSERT INTO order_header VALUES (1310,123,'2023-06-18 17:29', NULL);
INSERT INTO order_detail VALUES (1310,1023,4,26.98);
UPDATE order_header SET total = 107.92 WHERE order_id = 1310;
INSERT INTO order_header VALUES (1311,94,'2023-09-03 23:01', NULL);
INSERT INTO order_detail VALUES (1311,1001,2,7.89);
INSERT INTO order_detail VALUES (1311,1022,3,27.05);
INSERT INTO order_detail VALUES (1311,1019,1,6.67);
INSERT INTO order_detail VALUES (1311,1003,4,14.02);
UPDATE order_header SET total = 159.68 WHERE order_id = 1311;
INSERT INTO order_header VALUES (1312,40,'2024-01-30 02:44', NULL);
INSERT INTO order_detail VALUES (1312,1002,4,7.89);
INSERT INTO order_detail VALUES (1312,1012,3,13.67);
INSERT INTO order_detail VALUES (1312,1010,2,3.73);
INSERT INTO order_detail VALUES (1312,1003,3,8.98);
UPDATE order_header SET total = 106.97 WHERE order_id = 1312;
INSERT INTO order_header VALUES (1313,72,'2023-08-17 14:06', NULL);
INSERT INTO order_detail VALUES (1313,1002,1,7.27);
INSERT INTO order_detail VALUES (1313,1001,4,7.89);
INSERT INTO order_detail VALUES (1313,1018,2,3.33);
INSERT INTO order_detail VALUES (1313,1022,1,33.69);
UPDATE order_header SET total = 79.18 WHERE order_id = 1313;
INSERT INTO order_header VALUES (1314,126,'2023-09-02 09:08', NULL);
INSERT INTO order_detail VALUES (1314,1001,4,7.75);
INSERT INTO order_detail VALUES (1314,1012,3,14.25);
INSERT INTO order_detail VALUES (1314,1023,1,29.16);
UPDATE order_header SET total = 102.91 WHERE order_id = 1314;
INSERT INTO order_header VALUES (1315,32,'2023-04-04 14:40', NULL);
INSERT INTO order_detail VALUES (1315,1010,2,5.25);
INSERT INTO order_detail VALUES (1315,1018,3,3.33);
INSERT INTO order_detail VALUES (1315,1020,1,14.25);
INSERT INTO order_detail VALUES (1315,1023,4,22.55);
UPDATE order_header SET total = 124.94 WHERE order_id = 1315;
INSERT INTO order_header VALUES (1316,71,'2023-08-24 16:20', NULL);
INSERT INTO order_detail VALUES (1316,1018,2,2.68);
INSERT INTO order_detail VALUES (1316,1003,1,15.98);
INSERT INTO order_detail VALUES (1316,1010,2,4.67);
INSERT INTO order_detail VALUES (1316,1020,2,15.45);
INSERT INTO order_detail VALUES (1316,1023,2,28.68);
INSERT INTO order_detail VALUES (1316,1001,2,8.95);
UPDATE order_header SET total = 136.84 WHERE order_id = 1316;
INSERT INTO order_header VALUES (1317,28,'2023-08-31 22:19', NULL);
INSERT INTO order_detail VALUES (1317,1011,4,2.77);
INSERT INTO order_detail VALUES (1317,1023,4,26.98);
INSERT INTO order_detail VALUES (1317,1001,4,7.89);
INSERT INTO order_detail VALUES (1317,1024,3,41.77);
UPDATE order_header SET total = 275.87 WHERE order_id = 1317;
INSERT INTO order_header VALUES (1318,75,'2023-10-30 00:33', NULL);
INSERT INTO order_detail VALUES (1318,1020,4,19.93);
INSERT INTO order_detail VALUES (1318,1019,3,6.46);
INSERT INTO order_detail VALUES (1318,1023,2,22.83);
INSERT INTO order_detail VALUES (1318,1003,3,16.04);
INSERT INTO order_detail VALUES (1318,1001,3,7.89);
INSERT INTO order_detail VALUES (1318,1012,4,12.26);
UPDATE order_header SET total = 265.59 WHERE order_id = 1318;
INSERT INTO order_header VALUES (1319,101,'2023-07-19 08:55', NULL);
INSERT INTO order_detail VALUES (1319,1019,2,6.64);
INSERT INTO order_detail VALUES (1319,1018,4,3.33);
INSERT INTO order_detail VALUES (1319,1001,4,6.74);
INSERT INTO order_detail VALUES (1319,1024,1,43.98);
UPDATE order_header SET total = 97.54 WHERE order_id = 1319;
INSERT INTO order_header VALUES (1320,55,'2023-05-14 00:08', NULL);
INSERT INTO order_detail VALUES (1320,1010,4,4.3);
INSERT INTO order_detail VALUES (1320,1011,3,3.67);
INSERT INTO order_detail VALUES (1320,1020,3,18.78);
UPDATE order_header SET total = 84.55 WHERE order_id = 1320;
INSERT INTO order_header VALUES (1321,119,'2023-12-20 08:10', NULL);
INSERT INTO order_detail VALUES (1321,1001,1,6.38);
INSERT INTO order_detail VALUES (1321,1003,2,15.98);
INSERT INTO order_detail VALUES (1321,1020,2,18.78);
INSERT INTO order_detail VALUES (1321,1022,4,34.78);
INSERT INTO order_detail VALUES (1321,1024,4,43.98);
UPDATE order_header SET total = 390.94 WHERE order_id = 1321;
INSERT INTO order_header VALUES (1322,22,'2023-03-20 03:55', NULL);
INSERT INTO order_detail VALUES (1322,1002,2,7.39);
INSERT INTO order_detail VALUES (1322,1011,4,3.97);
INSERT INTO order_detail VALUES (1322,1024,2,43.98);
INSERT INTO order_detail VALUES (1322,1003,4,8.98);
INSERT INTO order_detail VALUES (1322,1010,2,4.67);
INSERT INTO order_detail VALUES (1322,1001,4,7.89);
UPDATE order_header SET total = 195.44 WHERE order_id = 1322;
INSERT INTO order_header VALUES (1323,124,'2023-08-23 16:18', NULL);
INSERT INTO order_detail VALUES (1323,1022,3,39.52);
INSERT INTO order_detail VALUES (1323,1011,4,4.15);
INSERT INTO order_detail VALUES (1323,1003,2,8.98);
INSERT INTO order_detail VALUES (1323,1023,1,26.98);
INSERT INTO order_detail VALUES (1323,1010,3,5.57);
UPDATE order_header SET total = 196.81 WHERE order_id = 1323;
INSERT INTO order_header VALUES (1324,99,'2023-10-11 12:39', NULL);
INSERT INTO order_detail VALUES (1324,1003,4,8.98);
INSERT INTO order_detail VALUES (1324,1019,4,6.67);
INSERT INTO order_detail VALUES (1324,1002,3,8.04);
UPDATE order_header SET total = 86.72 WHERE order_id = 1324;
INSERT INTO order_header VALUES (1325,59,'2024-01-07 23:39', NULL);
INSERT INTO order_detail VALUES (1325,1024,2,52.56);
INSERT INTO order_detail VALUES (1325,1019,3,7.58);
INSERT INTO order_detail VALUES (1325,1010,4,4.67);
INSERT INTO order_detail VALUES (1325,1020,1,18.78);
INSERT INTO order_detail VALUES (1325,1018,3,3.34);
INSERT INTO order_detail VALUES (1325,1001,1,8.49);
UPDATE order_header SET total = 183.83 WHERE order_id = 1325;
INSERT INTO order_header VALUES (1326,25,'2023-08-18 20:09', NULL);
INSERT INTO order_detail VALUES (1326,1022,3,34.78);
INSERT INTO order_detail VALUES (1326,1010,2,4.67);
INSERT INTO order_detail VALUES (1326,1012,2,13.78);
UPDATE order_header SET total = 141.24 WHERE order_id = 1326;
INSERT INTO order_header VALUES (1327,34,'2024-02-03 13:16', NULL);
INSERT INTO order_detail VALUES (1327,1024,4,47.87);
INSERT INTO order_detail VALUES (1327,1011,4,3.67);
INSERT INTO order_detail VALUES (1327,1018,4,3.33);
UPDATE order_header SET total = 219.48 WHERE order_id = 1327;
INSERT INTO order_header VALUES (1328,84,'2023-09-13 10:10', NULL);
INSERT INTO order_detail VALUES (1328,1001,2,6.05);
INSERT INTO order_detail VALUES (1328,1012,2,13.67);
INSERT INTO order_detail VALUES (1328,1024,3,43.98);
INSERT INTO order_detail VALUES (1328,1002,1,8.98);
INSERT INTO order_detail VALUES (1328,1003,4,14.94);
INSERT INTO order_detail VALUES (1328,1011,3,3.03);
UPDATE order_header SET total = 249.21 WHERE order_id = 1328;
INSERT INTO order_header VALUES (1329,57,'2023-06-06 05:00', NULL);
INSERT INTO order_detail VALUES (1329,1011,2,4.11);
INSERT INTO order_detail VALUES (1329,1010,1,4.32);
INSERT INTO order_detail VALUES (1329,1012,1,14.17);
UPDATE order_header SET total = 26.71 WHERE order_id = 1329;
INSERT INTO order_header VALUES (1330,82,'2023-08-20 17:29', NULL);
INSERT INTO order_detail VALUES (1330,1011,2,3.67);
INSERT INTO order_detail VALUES (1330,1010,3,4.96);
INSERT INTO order_detail VALUES (1330,1023,4,32.38);
UPDATE order_header SET total = 151.74 WHERE order_id = 1330;
INSERT INTO order_header VALUES (1331,53,'2023-10-04 14:07', NULL);
INSERT INTO order_detail VALUES (1331,1001,2,7.89);
UPDATE order_header SET total = 15.78 WHERE order_id = 1331;
INSERT INTO order_header VALUES (1332,79,'2023-10-23 22:55', NULL);
INSERT INTO order_detail VALUES (1332,1003,2,9.9);
UPDATE order_header SET total = 19.8 WHERE order_id = 1332;
INSERT INTO order_header VALUES (1333,123,'2023-10-24 20:30', NULL);
INSERT INTO order_detail VALUES (1333,1012,1,13.67);
INSERT INTO order_detail VALUES (1333,1010,3,3.72);
INSERT INTO order_detail VALUES (1333,1019,1,6.67);
INSERT INTO order_detail VALUES (1333,1023,3,23.68);
UPDATE order_header SET total = 102.54 WHERE order_id = 1333;
INSERT INTO order_header VALUES (1334,21,'2023-03-20 07:34', NULL);
INSERT INTO order_detail VALUES (1334,1023,3,32.28);
INSERT INTO order_detail VALUES (1334,1003,3,18.6);
INSERT INTO order_detail VALUES (1334,1010,1,4.06);
UPDATE order_header SET total = 156.7 WHERE order_id = 1334;
INSERT INTO order_header VALUES (1335,86,'2023-10-28 00:43', NULL);
INSERT INTO order_detail VALUES (1335,1018,1,2.89);
INSERT INTO order_detail VALUES (1335,1019,1,8.22);
UPDATE order_header SET total = 11.11 WHERE order_id = 1335;
INSERT INTO order_header VALUES (1336,96,'2023-02-21 19:38', NULL);
INSERT INTO order_detail VALUES (1336,1002,2,7.89);
INSERT INTO order_detail VALUES (1336,1020,4,18.78);
UPDATE order_header SET total = 90.9 WHERE order_id = 1336;
INSERT INTO order_header VALUES (1337,81,'2023-08-20 05:14', NULL);
INSERT INTO order_detail VALUES (1337,1022,3,34.78);
UPDATE order_header SET total = 104.34 WHERE order_id = 1337;
INSERT INTO order_header VALUES (1338,37,'2023-10-27 09:46', NULL);
INSERT INTO order_detail VALUES (1338,1024,4,44.09);
INSERT INTO order_detail VALUES (1338,1019,3,6.67);
INSERT INTO order_detail VALUES (1338,1012,3,13.67);
INSERT INTO order_detail VALUES (1338,1001,4,8.53);
INSERT INTO order_detail VALUES (1338,1003,3,15.66);
UPDATE order_header SET total = 318.48 WHERE order_id = 1338;
INSERT INTO order_header VALUES (1339,86,'2023-06-18 03:43', NULL);
INSERT INTO order_detail VALUES (1339,1023,4,26.98);
UPDATE order_header SET total = 107.92 WHERE order_id = 1339;
INSERT INTO order_header VALUES (1340,110,'2023-11-29 01:06', NULL);
INSERT INTO order_detail VALUES (1340,1024,1,41.13);
INSERT INTO order_detail VALUES (1340,1018,2,2.87);
INSERT INTO order_detail VALUES (1340,1012,1,13.67);
INSERT INTO order_detail VALUES (1340,1003,3,10.4);
INSERT INTO order_detail VALUES (1340,1019,3,6.67);
INSERT INTO order_detail VALUES (1340,1001,2,7.87);
UPDATE order_header SET total = 127.49 WHERE order_id = 1340;
INSERT INTO order_header VALUES (1341,56,'2023-01-19 18:38', NULL);
INSERT INTO order_detail VALUES (1341,1019,2,6.67);
INSERT INTO order_detail VALUES (1341,1012,2,11.13);
INSERT INTO order_detail VALUES (1341,1018,1,4.05);
UPDATE order_header SET total = 39.65 WHERE order_id = 1341;
INSERT INTO order_header VALUES (1342,119,'2023-04-27 19:48', NULL);
INSERT INTO order_detail VALUES (1342,1018,3,4.15);
INSERT INTO order_detail VALUES (1342,1020,3,18.95);
INSERT INTO order_detail VALUES (1342,1012,4,15.44);
INSERT INTO order_detail VALUES (1342,1003,2,10.86);
INSERT INTO order_detail VALUES (1342,1010,4,4.42);
UPDATE order_header SET total = 170.46 WHERE order_id = 1342;
INSERT INTO order_header VALUES (1343,52,'2023-02-11 13:34', NULL);
INSERT INTO order_detail VALUES (1343,1023,1,31.14);
INSERT INTO order_detail VALUES (1343,1011,3,3.67);
INSERT INTO order_detail VALUES (1343,1003,2,13.89);
INSERT INTO order_detail VALUES (1343,1010,3,4.67);
INSERT INTO order_detail VALUES (1343,1012,3,13.67);
UPDATE order_header SET total = 124.95 WHERE order_id = 1343;
INSERT INTO order_header VALUES (1344,40,'2023-02-07 17:58', NULL);
INSERT INTO order_detail VALUES (1344,1002,2,9.08);
INSERT INTO order_detail VALUES (1344,1019,1,7.09);
INSERT INTO order_detail VALUES (1344,1012,1,10.63);
INSERT INTO order_detail VALUES (1344,1003,1,15.03);
INSERT INTO order_detail VALUES (1344,1010,1,4.67);
UPDATE order_header SET total = 55.58 WHERE order_id = 1344;
INSERT INTO order_header VALUES (1345,62,'2023-04-30 13:16', NULL);
INSERT INTO order_detail VALUES (1345,1012,4,13.67);
INSERT INTO order_detail VALUES (1345,1024,2,33.26);
INSERT INTO order_detail VALUES (1345,1019,1,6.67);
INSERT INTO order_detail VALUES (1345,1022,2,34.78);
INSERT INTO order_detail VALUES (1345,1010,2,4.67);
UPDATE order_header SET total = 206.77 WHERE order_id = 1345;
INSERT INTO order_header VALUES (1346,42,'2023-07-01 15:27', NULL);
INSERT INTO order_detail VALUES (1346,1010,3,5.57);
INSERT INTO order_detail VALUES (1346,1020,2,16.98);
INSERT INTO order_detail VALUES (1346,1018,3,4.11);
INSERT INTO order_detail VALUES (1346,1003,2,16.04);
UPDATE order_header SET total = 95.08 WHERE order_id = 1346;
INSERT INTO order_header VALUES (1347,116,'2023-10-14 14:55', NULL);
INSERT INTO order_detail VALUES (1347,1010,3,4.67);
UPDATE order_header SET total = 14.01 WHERE order_id = 1347;
INSERT INTO order_header VALUES (1348,63,'2023-06-18 14:22', NULL);
INSERT INTO order_detail VALUES (1348,1019,2,7.56);
INSERT INTO order_detail VALUES (1348,1002,3,7.89);
UPDATE order_header SET total = 38.79 WHERE order_id = 1348;
INSERT INTO order_header VALUES (1349,58,'2023-04-16 13:39', NULL);
INSERT INTO order_detail VALUES (1349,1001,2,15.98);
INSERT INTO order_detail VALUES (1349,1011,3,2.81);
INSERT INTO order_detail VALUES (1349,1002,2,6.78);
INSERT INTO order_detail VALUES (1349,1003,3,8.98);
UPDATE order_header SET total = 80.89 WHERE order_id = 1349;
INSERT INTO order_header VALUES (1350,53,'2023-10-11 20:04', NULL);
INSERT INTO order_detail VALUES (1350,1002,3,7.89);
INSERT INTO order_detail VALUES (1350,1012,3,12.78);
UPDATE order_header SET total = 62.01 WHERE order_id = 1350;
INSERT INTO order_header VALUES (1351,57,'2023-12-05 15:05', NULL);
INSERT INTO order_detail VALUES (1351,1002,3,7.89);
INSERT INTO order_detail VALUES (1351,1010,2,4.67);
UPDATE order_header SET total = 33.01 WHERE order_id = 1351;
INSERT INTO order_header VALUES (1352,107,'2023-11-12 21:16', NULL);
INSERT INTO order_detail VALUES (1352,1001,2,7.89);
INSERT INTO order_detail VALUES (1352,1020,4,18.78);
INSERT INTO order_detail VALUES (1352,1024,1,41.52);
INSERT INTO order_detail VALUES (1352,1010,3,4.59);
INSERT INTO order_detail VALUES (1352,1012,3,13.67);
UPDATE order_header SET total = 187.2 WHERE order_id = 1352;
INSERT INTO order_header VALUES (1353,77,'2023-12-22 21:03', NULL);
INSERT INTO order_detail VALUES (1353,1024,2,52.53);
INSERT INTO order_detail VALUES (1353,1011,2,3.67);
INSERT INTO order_detail VALUES (1353,1018,3,2.64);
INSERT INTO order_detail VALUES (1353,1010,1,4.71);
UPDATE order_header SET total = 125.03 WHERE order_id = 1353;
INSERT INTO order_header VALUES (1354,39,'2023-10-26 18:58', NULL);
INSERT INTO order_detail VALUES (1354,1024,3,36.93);
UPDATE order_header SET total = 110.79 WHERE order_id = 1354;
INSERT INTO order_header VALUES (1355,39,'2023-05-16 06:32', NULL);
INSERT INTO order_detail VALUES (1355,1001,3,13.59);
INSERT INTO order_detail VALUES (1355,1002,2,7.89);
INSERT INTO order_detail VALUES (1355,1018,3,3.86);
INSERT INTO order_detail VALUES (1355,1024,3,46.27);
INSERT INTO order_detail VALUES (1355,1003,2,8.98);
INSERT INTO order_detail VALUES (1355,1011,3,3.3);
UPDATE order_header SET total = 234.8 WHERE order_id = 1355;
INSERT INTO order_header VALUES (1356,115,'2023-06-27 09:37', NULL);
INSERT INTO order_detail VALUES (1356,1011,4,3.83);
INSERT INTO order_detail VALUES (1356,1022,4,34.78);
INSERT INTO order_detail VALUES (1356,1020,4,14.89);
INSERT INTO order_detail VALUES (1356,1003,2,10.96);
UPDATE order_header SET total = 235.92 WHERE order_id = 1356;
INSERT INTO order_header VALUES (1357,63,'2023-04-18 08:57', NULL);
INSERT INTO order_detail VALUES (1357,1002,3,7.6);
INSERT INTO order_detail VALUES (1357,1022,4,34.78);
INSERT INTO order_detail VALUES (1357,1023,3,20.55);
INSERT INTO order_detail VALUES (1357,1003,1,8.98);
UPDATE order_header SET total = 232.55 WHERE order_id = 1357;
INSERT INTO order_header VALUES (1358,29,'2023-06-19 09:12', NULL);
INSERT INTO order_detail VALUES (1358,1023,1,33.21);
INSERT INTO order_detail VALUES (1358,1019,3,5.35);
INSERT INTO order_detail VALUES (1358,1001,2,8.64);
INSERT INTO order_detail VALUES (1358,1003,4,13.57);
INSERT INTO order_detail VALUES (1358,1002,4,6.84);
UPDATE order_header SET total = 148.18 WHERE order_id = 1358;
INSERT INTO order_header VALUES (1359,94,'2023-09-26 03:29', NULL);
INSERT INTO order_detail VALUES (1359,1002,4,6.19);
UPDATE order_header SET total = 24.76 WHERE order_id = 1359;
INSERT INTO order_header VALUES (1360,132,'2023-04-16 04:29', NULL);
INSERT INTO order_detail VALUES (1360,1024,1,43.98);
INSERT INTO order_detail VALUES (1360,1002,4,7.49);
UPDATE order_header SET total = 73.94 WHERE order_id = 1360;
INSERT INTO order_header VALUES (1361,113,'2023-05-07 13:22', NULL);
INSERT INTO order_detail VALUES (1361,1010,4,4.67);
INSERT INTO order_detail VALUES (1361,1001,2,7.54);
INSERT INTO order_detail VALUES (1361,1002,4,9.51);
INSERT INTO order_detail VALUES (1361,1020,2,18.78);
INSERT INTO order_detail VALUES (1361,1003,1,19.54);
UPDATE order_header SET total = 128.9 WHERE order_id = 1361;
INSERT INTO order_header VALUES (1362,40,'2023-03-22 19:41', NULL);
INSERT INTO order_detail VALUES (1362,1011,3,3.05);
INSERT INTO order_detail VALUES (1362,1019,2,6.67);
INSERT INTO order_detail VALUES (1362,1018,4,3.56);
UPDATE order_header SET total = 36.73 WHERE order_id = 1362;
INSERT INTO order_header VALUES (1363,96,'2024-01-19 10:40', NULL);
INSERT INTO order_detail VALUES (1363,1010,4,3.7);
INSERT INTO order_detail VALUES (1363,1012,2,13.67);
INSERT INTO order_detail VALUES (1363,1003,4,10.42);
INSERT INTO order_detail VALUES (1363,1019,2,5.06);
UPDATE order_header SET total = 93.94 WHERE order_id = 1363;
INSERT INTO order_header VALUES (1364,22,'2023-04-01 04:21', NULL);
INSERT INTO order_detail VALUES (1364,1023,2,26.98);
INSERT INTO order_detail VALUES (1364,1011,2,2.84);
INSERT INTO order_detail VALUES (1364,1020,1,16.98);
UPDATE order_header SET total = 76.62 WHERE order_id = 1364;
INSERT INTO order_header VALUES (1365,16,'2023-11-03 16:32', NULL);
INSERT INTO order_detail VALUES (1365,1003,3,15.98);
UPDATE order_header SET total = 47.94 WHERE order_id = 1365;
INSERT INTO order_header VALUES (1366,97,'2023-12-09 01:50', NULL);
INSERT INTO order_detail VALUES (1366,1011,2,3.67);
UPDATE order_header SET total = 7.34 WHERE order_id = 1366;
INSERT INTO order_header VALUES (1367,60,'2023-08-08 11:32', NULL);
INSERT INTO order_detail VALUES (1367,1003,4,9.69);
UPDATE order_header SET total = 38.76 WHERE order_id = 1367;
INSERT INTO order_header VALUES (1368,45,'2023-11-29 06:49', NULL);
INSERT INTO order_detail VALUES (1368,1012,3,13.67);
INSERT INTO order_detail VALUES (1368,1002,3,7.89);
INSERT INTO order_detail VALUES (1368,1019,4,6.67);
INSERT INTO order_detail VALUES (1368,1010,2,4.99);
INSERT INTO order_detail VALUES (1368,1001,3,7.89);
UPDATE order_header SET total = 125.01 WHERE order_id = 1368;
INSERT INTO order_header VALUES (1369,95,'2023-09-04 03:32', NULL);
INSERT INTO order_detail VALUES (1369,1011,1,4.11);
UPDATE order_header SET total = 4.11 WHERE order_id = 1369;
INSERT INTO order_header VALUES (1370,106,'2023-05-05 13:25', NULL);
INSERT INTO order_detail VALUES (1370,1001,2,15.98);
INSERT INTO order_detail VALUES (1370,1012,4,13.67);
INSERT INTO order_detail VALUES (1370,1023,3,24.52);
INSERT INTO order_detail VALUES (1370,1024,1,43.98);
INSERT INTO order_detail VALUES (1370,1003,4,8.98);
UPDATE order_header SET total = 240.1 WHERE order_id = 1370;
INSERT INTO order_header VALUES (1371,46,'2024-01-20 20:00', NULL);
INSERT INTO order_detail VALUES (1371,1020,3,20.0);
UPDATE order_header SET total = 60.0 WHERE order_id = 1371;
INSERT INTO order_header VALUES (1372,18,'2023-09-09 16:57', NULL);
INSERT INTO order_detail VALUES (1372,1019,4,6.67);
UPDATE order_header SET total = 26.68 WHERE order_id = 1372;
INSERT INTO order_header VALUES (1373,49,'2023-03-26 13:08', NULL);
INSERT INTO order_detail VALUES (1373,1019,1,6.67);
INSERT INTO order_detail VALUES (1373,1001,3,6.58);
INSERT INTO order_detail VALUES (1373,1002,4,8.32);
INSERT INTO order_detail VALUES (1373,1022,4,34.78);
INSERT INTO order_detail VALUES (1373,1024,4,41.37);
INSERT INTO order_detail VALUES (1373,1010,1,4.67);
UPDATE order_header SET total = 368.96 WHERE order_id = 1373;
INSERT INTO order_header VALUES (1374,127,'2023-06-03 16:36', NULL);
INSERT INTO order_detail VALUES (1374,1019,1,7.39);
INSERT INTO order_detail VALUES (1374,1011,2,3.1);
INSERT INTO order_detail VALUES (1374,1001,1,7.89);
INSERT INTO order_detail VALUES (1374,1010,3,5.66);
INSERT INTO order_detail VALUES (1374,1012,4,13.67);
UPDATE order_header SET total = 93.14 WHERE order_id = 1374;
INSERT INTO order_header VALUES (1375,57,'2023-07-16 14:19', NULL);
INSERT INTO order_detail VALUES (1375,1001,3,7.89);
INSERT INTO order_detail VALUES (1375,1003,3,8.98);
INSERT INTO order_detail VALUES (1375,1024,4,43.98);
INSERT INTO order_detail VALUES (1375,1002,3,7.89);
UPDATE order_header SET total = 250.2 WHERE order_id = 1375;
INSERT INTO order_header VALUES (1376,93,'2023-07-17 19:45', NULL);
INSERT INTO order_detail VALUES (1376,1020,2,19.74);
INSERT INTO order_detail VALUES (1376,1024,2,49.94);
INSERT INTO order_detail VALUES (1376,1018,4,3.47);
INSERT INTO order_detail VALUES (1376,1003,1,8.98);
UPDATE order_header SET total = 162.22 WHERE order_id = 1376;
INSERT INTO order_header VALUES (1377,34,'2023-08-05 15:45', NULL);
INSERT INTO order_detail VALUES (1377,1023,2,23.06);
INSERT INTO order_detail VALUES (1377,1024,4,43.98);
UPDATE order_header SET total = 222.04 WHERE order_id = 1377;
INSERT INTO order_header VALUES (1378,66,'2023-03-28 14:36', NULL);
INSERT INTO order_detail VALUES (1378,1001,2,15.98);
INSERT INTO order_detail VALUES (1378,1003,2,8.99);
INSERT INTO order_detail VALUES (1378,1011,1,4.25);
INSERT INTO order_detail VALUES (1378,1002,2,8.88);
UPDATE order_header SET total = 71.95 WHERE order_id = 1378;
INSERT INTO order_header VALUES (1379,113,'2024-01-24 18:19', NULL);
INSERT INTO order_detail VALUES (1379,1010,1,4.87);
INSERT INTO order_detail VALUES (1379,1019,4,7.54);
UPDATE order_header SET total = 35.03 WHERE order_id = 1379;
INSERT INTO order_header VALUES (1380,11,'2023-02-01 08:04', NULL);
INSERT INTO order_detail VALUES (1380,1022,4,31.95);
INSERT INTO order_detail VALUES (1380,1003,4,17.43);
INSERT INTO order_detail VALUES (1380,1023,3,26.98);
UPDATE order_header SET total = 278.46 WHERE order_id = 1380;
INSERT INTO order_header VALUES (1381,114,'2023-05-03 19:18', NULL);
INSERT INTO order_detail VALUES (1381,1002,2,6.4);
INSERT INTO order_detail VALUES (1381,1019,3,6.67);
INSERT INTO order_detail VALUES (1381,1003,2,16.93);
UPDATE order_header SET total = 66.67 WHERE order_id = 1381;
INSERT INTO order_header VALUES (1382,94,'2023-09-01 05:50', NULL);
INSERT INTO order_detail VALUES (1382,1018,2,3.33);
INSERT INTO order_detail VALUES (1382,1019,4,6.67);
INSERT INTO order_detail VALUES (1382,1011,1,4.48);
INSERT INTO order_detail VALUES (1382,1001,4,7.89);
INSERT INTO order_detail VALUES (1382,1024,1,43.98);
UPDATE order_header SET total = 113.36 WHERE order_id = 1382;
INSERT INTO order_header VALUES (1383,47,'2023-11-07 14:39', NULL);
INSERT INTO order_detail VALUES (1383,1024,2,43.98);
INSERT INTO order_detail VALUES (1383,1022,1,35.49);
UPDATE order_header SET total = 123.45 WHERE order_id = 1383;
INSERT INTO order_header VALUES (1384,41,'2023-04-19 13:54', NULL);
INSERT INTO order_detail VALUES (1384,1012,4,13.67);
INSERT INTO order_detail VALUES (1384,1003,1,8.98);
UPDATE order_header SET total = 63.66 WHERE order_id = 1384;
INSERT INTO order_header VALUES (1385,128,'2023-10-01 17:27', NULL);
INSERT INTO order_detail VALUES (1385,1012,2,11.04);
INSERT INTO order_detail VALUES (1385,1010,1,4.3);
INSERT INTO order_detail VALUES (1385,1002,2,7.89);
INSERT INTO order_detail VALUES (1385,1020,1,18.78);
INSERT INTO order_detail VALUES (1385,1019,2,6.67);
INSERT INTO order_detail VALUES (1385,1018,4,3.33);
UPDATE order_header SET total = 87.6 WHERE order_id = 1385;
INSERT INTO order_header VALUES (1386,64,'2023-06-09 04:54', NULL);
INSERT INTO order_detail VALUES (1386,1022,1,34.78);
UPDATE order_header SET total = 34.78 WHERE order_id = 1386;
INSERT INTO order_header VALUES (1387,68,'2023-06-11 14:03', NULL);
INSERT INTO order_detail VALUES (1387,1001,3,7.89);
INSERT INTO order_detail VALUES (1387,1011,4,3.67);
UPDATE order_header SET total = 38.35 WHERE order_id = 1387;
INSERT INTO order_header VALUES (1388,37,'2023-09-11 10:08', NULL);
INSERT INTO order_detail VALUES (1388,1012,4,15.82);
INSERT INTO order_detail VALUES (1388,1022,2,34.78);
INSERT INTO order_detail VALUES (1388,1003,4,17.4);
UPDATE order_header SET total = 202.44 WHERE order_id = 1388;
INSERT INTO order_header VALUES (1389,54,'2024-01-23 16:01', NULL);
INSERT INTO order_detail VALUES (1389,1001,1,15.98);
INSERT INTO order_detail VALUES (1389,1003,3,7.47);
INSERT INTO order_detail VALUES (1389,1019,2,6.61);
INSERT INTO order_detail VALUES (1389,1012,2,15.75);
UPDATE order_header SET total = 83.11 WHERE order_id = 1389;
INSERT INTO order_header VALUES (1390,35,'2024-01-12 13:31', NULL);
INSERT INTO order_detail VALUES (1390,1002,4,6.12);
INSERT INTO order_detail VALUES (1390,1023,3,26.98);
INSERT INTO order_detail VALUES (1390,1018,2,3.33);
INSERT INTO order_detail VALUES (1390,1010,4,3.78);
INSERT INTO order_detail VALUES (1390,1024,4,48.11);
INSERT INTO order_detail VALUES (1390,1022,2,34.78);
UPDATE order_header SET total = 389.2 WHERE order_id = 1390;
INSERT INTO order_header VALUES (1391,58,'2024-02-02 15:25', NULL);
INSERT INTO order_detail VALUES (1391,1003,1,8.93);
INSERT INTO order_detail VALUES (1391,1024,2,45.58);
INSERT INTO order_detail VALUES (1391,1002,4,8.86);
INSERT INTO order_detail VALUES (1391,1019,2,8.34);
INSERT INTO order_detail VALUES (1391,1010,4,3.79);
INSERT INTO order_detail VALUES (1391,1022,3,41.89);
UPDATE order_header SET total = 293.04 WHERE order_id = 1391;
INSERT INTO order_header VALUES (1392,111,'2023-10-03 14:13', NULL);
INSERT INTO order_detail VALUES (1392,1024,2,43.98);
INSERT INTO order_detail VALUES (1392,1002,2,7.68);
UPDATE order_header SET total = 103.32 WHERE order_id = 1392;
INSERT INTO order_header VALUES (1393,50,'2023-03-04 00:35', NULL);
INSERT INTO order_detail VALUES (1393,1003,3,8.98);
UPDATE order_header SET total = 26.94 WHERE order_id = 1393;
INSERT INTO order_header VALUES (1394,31,'2023-08-05 11:33', NULL);
INSERT INTO order_detail VALUES (1394,1018,3,3.33);
INSERT INTO order_detail VALUES (1394,1001,3,7.89);
INSERT INTO order_detail VALUES (1394,1011,2,3.67);
INSERT INTO order_detail VALUES (1394,1020,1,15.85);
INSERT INTO order_detail VALUES (1394,1003,3,15.98);
INSERT INTO order_detail VALUES (1394,1022,2,34.78);
UPDATE order_header SET total = 174.35 WHERE order_id = 1394;
INSERT INTO order_header VALUES (1395,87,'2023-10-10 03:49', NULL);
INSERT INTO order_detail VALUES (1395,1023,4,32.98);
INSERT INTO order_detail VALUES (1395,1018,4,3.33);
UPDATE order_header SET total = 145.24 WHERE order_id = 1395;
INSERT INTO order_header VALUES (1396,28,'2023-10-02 16:15', NULL);
INSERT INTO order_detail VALUES (1396,1022,2,28.25);
INSERT INTO order_detail VALUES (1396,1023,1,26.98);
UPDATE order_header SET total = 83.48 WHERE order_id = 1396;
INSERT INTO order_header VALUES (1397,62,'2023-02-03 06:27', NULL);
INSERT INTO order_detail VALUES (1397,1003,2,7.21);
INSERT INTO order_detail VALUES (1397,1020,1,20.92);
INSERT INTO order_detail VALUES (1397,1010,3,4.67);
UPDATE order_header SET total = 49.35 WHERE order_id = 1397;
INSERT INTO order_header VALUES (1398,113,'2023-09-08 08:21', NULL);
INSERT INTO order_detail VALUES (1398,1011,2,4.11);
UPDATE order_header SET total = 8.22 WHERE order_id = 1398;
INSERT INTO order_header VALUES (1399,133,'2023-09-30 03:22', NULL);
INSERT INTO order_detail VALUES (1399,1020,2,20.99);
INSERT INTO order_detail VALUES (1399,1003,1,15.98);
INSERT INTO order_detail VALUES (1399,1012,3,13.67);
INSERT INTO order_detail VALUES (1399,1010,2,4.67);
INSERT INTO order_detail VALUES (1399,1018,4,3.33);
UPDATE order_header SET total = 121.63 WHERE order_id = 1399;
INSERT INTO order_header VALUES (1400,33,'2023-08-13 08:04', NULL);
INSERT INTO order_detail VALUES (1400,1024,3,39.86);
INSERT INTO order_detail VALUES (1400,1020,1,18.78);
INSERT INTO order_detail VALUES (1400,1010,1,4.67);
UPDATE order_header SET total = 143.03 WHERE order_id = 1400;
INSERT INTO order_header VALUES (1401,130,'2023-02-17 20:24', NULL);
INSERT INTO order_detail VALUES (1401,1003,1,9.5);
INSERT INTO order_detail VALUES (1401,1010,1,4.67);
UPDATE order_header SET total = 14.17 WHERE order_id = 1401;
INSERT INTO order_header VALUES (1402,99,'2023-10-01 14:21', NULL);
INSERT INTO order_detail VALUES (1402,1024,3,43.98);
INSERT INTO order_detail VALUES (1402,1002,3,7.89);
INSERT INTO order_detail VALUES (1402,1003,4,13.35);
INSERT INTO order_detail VALUES (1402,1019,1,7.27);
INSERT INTO order_detail VALUES (1402,1012,1,13.55);
INSERT INTO order_detail VALUES (1402,1018,3,3.73);
UPDATE order_header SET total = 241.02 WHERE order_id = 1402;
INSERT INTO order_header VALUES (1403,82,'2023-07-21 14:22', NULL);
INSERT INTO order_detail VALUES (1403,1023,3,24.95);
INSERT INTO order_detail VALUES (1403,1018,2,2.51);
UPDATE order_header SET total = 79.87 WHERE order_id = 1403;
INSERT INTO order_header VALUES (1404,65,'2023-09-09 04:31', NULL);
INSERT INTO order_detail VALUES (1404,1003,4,8.37);
INSERT INTO order_detail VALUES (1404,1010,2,4.67);
UPDATE order_header SET total = 42.82 WHERE order_id = 1404;
INSERT INTO order_header VALUES (1405,44,'2023-02-25 15:34', NULL);
INSERT INTO order_detail VALUES (1405,1001,1,7.58);
INSERT INTO order_detail VALUES (1405,1022,3,34.78);
INSERT INTO order_detail VALUES (1405,1024,2,43.98);
INSERT INTO order_detail VALUES (1405,1011,4,3.67);
UPDATE order_header SET total = 214.56 WHERE order_id = 1405;
INSERT INTO order_header VALUES (1407,26,'2023-03-21 05:07', NULL);
INSERT INTO order_detail VALUES (1407,1002,3,8.92);
INSERT INTO order_detail VALUES (1407,1001,2,7.89);
INSERT INTO order_detail VALUES (1407,1003,2,18.11);
UPDATE order_header SET total = 78.76 WHERE order_id = 1407;
INSERT INTO order_header VALUES (1408,120,'2023-05-15 00:06', NULL);
INSERT INTO order_detail VALUES (1408,1018,2,3.17);
INSERT INTO order_detail VALUES (1408,1003,3,15.98);
INSERT INTO order_detail VALUES (1408,1002,2,8.35);
INSERT INTO order_detail VALUES (1408,1019,1,6.67);
INSERT INTO order_detail VALUES (1408,1001,4,8.11);
INSERT INTO order_detail VALUES (1408,1022,2,33.49);
UPDATE order_header SET total = 177.07 WHERE order_id = 1408;
INSERT INTO order_header VALUES (1409,17,'2023-09-19 14:11', NULL);
INSERT INTO order_detail VALUES (1409,1001,2,6.12);
INSERT INTO order_detail VALUES (1409,1023,3,26.6);
INSERT INTO order_detail VALUES (1409,1011,1,3.22);
INSERT INTO order_detail VALUES (1409,1024,4,39.68);
UPDATE order_header SET total = 253.98 WHERE order_id = 1409;
INSERT INTO order_header VALUES (1410,22,'2023-12-09 20:57', NULL);
INSERT INTO order_detail VALUES (1410,1024,2,43.98);
UPDATE order_header SET total = 87.96 WHERE order_id = 1410;
INSERT INTO order_header VALUES (1411,21,'2023-02-24 00:56', NULL);
INSERT INTO order_detail VALUES (1411,1001,3,7.89);
INSERT INTO order_detail VALUES (1411,1022,2,34.78);
UPDATE order_header SET total = 93.23 WHERE order_id = 1411;
INSERT INTO order_header VALUES (1412,29,'2023-01-23 14:51', NULL);
INSERT INTO order_detail VALUES (1412,1020,4,18.78);
INSERT INTO order_detail VALUES (1412,1022,1,30.85);
UPDATE order_header SET total = 105.97 WHERE order_id = 1412;
INSERT INTO order_header VALUES (1413,133,'2023-03-08 12:07', NULL);
INSERT INTO order_detail VALUES (1413,1023,4,26.98);
INSERT INTO order_detail VALUES (1413,1022,4,30.81);
INSERT INTO order_detail VALUES (1413,1003,2,9.3);
UPDATE order_header SET total = 249.76 WHERE order_id = 1413;
INSERT INTO order_header VALUES (1414,85,'2023-12-23 12:25', NULL);
INSERT INTO order_detail VALUES (1414,1001,2,8.02);
UPDATE order_header SET total = 16.04 WHERE order_id = 1414;
INSERT INTO order_header VALUES (1415,47,'2023-01-21 09:26', NULL);
INSERT INTO order_detail VALUES (1415,1019,3,8.16);
INSERT INTO order_detail VALUES (1415,1022,3,34.78);
INSERT INTO order_detail VALUES (1415,1010,4,4.67);
INSERT INTO order_detail VALUES (1415,1012,3,10.64);
INSERT INTO order_detail VALUES (1415,1018,1,3.33);
INSERT INTO order_detail VALUES (1415,1023,2,26.98);
UPDATE order_header SET total = 236.71 WHERE order_id = 1415;
INSERT INTO order_header VALUES (1416,45,'2023-04-01 00:11', NULL);
INSERT INTO order_detail VALUES (1416,1003,3,16.63);
INSERT INTO order_detail VALUES (1416,1024,4,38.08);
INSERT INTO order_detail VALUES (1416,1012,4,16.42);
UPDATE order_header SET total = 267.89 WHERE order_id = 1416;
INSERT INTO order_header VALUES (1417,21,'2023-09-11 09:04', NULL);
INSERT INTO order_detail VALUES (1417,1024,4,43.98);
INSERT INTO order_detail VALUES (1417,1002,2,6.2);
UPDATE order_header SET total = 188.32 WHERE order_id = 1417;
INSERT INTO order_header VALUES (1418,41,'2023-08-21 12:00', NULL);
INSERT INTO order_detail VALUES (1418,1020,2,14.87);
INSERT INTO order_detail VALUES (1418,1011,2,3.67);
INSERT INTO order_detail VALUES (1418,1022,1,34.78);
INSERT INTO order_detail VALUES (1418,1002,1,15.98);
INSERT INTO order_detail VALUES (1418,1001,1,7.89);
INSERT INTO order_detail VALUES (1418,1003,3,8.98);
UPDATE order_header SET total = 122.67 WHERE order_id = 1418;
INSERT INTO order_header VALUES (1419,20,'2023-04-14 08:39', NULL);
INSERT INTO order_detail VALUES (1419,1023,1,20.84);
INSERT INTO order_detail VALUES (1419,1024,3,52.48);
UPDATE order_header SET total = 178.28 WHERE order_id = 1419;
INSERT INTO order_header VALUES (1420,63,'2023-03-14 16:41', NULL);
INSERT INTO order_detail VALUES (1420,1018,1,4.15);
UPDATE order_header SET total = 4.15 WHERE order_id = 1420;
INSERT INTO order_header VALUES (1421,38,'2023-02-22 07:02', NULL);
INSERT INTO order_detail VALUES (1421,1019,3,6.67);
INSERT INTO order_detail VALUES (1421,1024,4,47.66);
INSERT INTO order_detail VALUES (1421,1002,3,7.89);
UPDATE order_header SET total = 234.32 WHERE order_id = 1421;
INSERT INTO order_header VALUES (1422,46,'2023-06-28 15:29', NULL);
INSERT INTO order_detail VALUES (1422,1002,4,9.06);
UPDATE order_header SET total = 36.24 WHERE order_id = 1422;
INSERT INTO order_header VALUES (1423,134,'2023-09-02 14:23', NULL);
INSERT INTO order_detail VALUES (1423,1002,4,8.65);
UPDATE order_header SET total = 34.6 WHERE order_id = 1423;
INSERT INTO order_header VALUES (1424,62,'2023-11-05 20:13', NULL);
INSERT INTO order_detail VALUES (1424,1001,4,17.7);
INSERT INTO order_detail VALUES (1424,1002,2,7.89);
INSERT INTO order_detail VALUES (1424,1003,2,7.65);
INSERT INTO order_detail VALUES (1424,1020,1,18.54);
INSERT INTO order_detail VALUES (1424,1024,2,7.89);
INSERT INTO order_detail VALUES (1424,1010,1,4.67);
UPDATE order_header SET total = 140.87 WHERE order_id = 1424;
INSERT INTO order_header VALUES (1425,56,'2024-02-03 15:19', NULL);
INSERT INTO order_detail VALUES (1425,1012,4,13.67);
INSERT INTO order_detail VALUES (1425,1018,4,3.67);
UPDATE order_header SET total = 69.36 WHERE order_id = 1425;
INSERT INTO order_header VALUES (1426,94,'2023-10-25 13:33', NULL);
INSERT INTO order_detail VALUES (1426,1019,2,6.67);
UPDATE order_header SET total = 13.34 WHERE order_id = 1426;
INSERT INTO order_header VALUES (1427,70,'2024-01-16 13:12', NULL);
INSERT INTO order_detail VALUES (1427,1003,1,15.98);
INSERT INTO order_detail VALUES (1427,1020,1,18.78);
UPDATE order_header SET total = 34.76 WHERE order_id = 1427;
INSERT INTO order_header VALUES (1428,32,'2023-09-15 22:58', NULL);
INSERT INTO order_detail VALUES (1428,1012,3,13.67);
INSERT INTO order_detail VALUES (1428,1011,4,3.67);
UPDATE order_header SET total = 55.69 WHERE order_id = 1428;
INSERT INTO order_header VALUES (1429,26,'2024-01-16 07:04', NULL);
INSERT INTO order_detail VALUES (1429,1001,4,8.45);
INSERT INTO order_detail VALUES (1429,1011,4,4.23);
UPDATE order_header SET total = 50.72 WHERE order_id = 1429;
INSERT INTO order_header VALUES (1430,92,'2023-08-06 09:25', NULL);
INSERT INTO order_detail VALUES (1430,1003,1,6.78);
INSERT INTO order_detail VALUES (1430,1018,3,2.83);
UPDATE order_header SET total = 15.27 WHERE order_id = 1430;
INSERT INTO order_header VALUES (1431,128,'2023-01-17 04:21', NULL);
INSERT INTO order_detail VALUES (1431,1024,3,43.98);
INSERT INTO order_detail VALUES (1431,1010,4,4.67);
UPDATE order_header SET total = 150.62 WHERE order_id = 1431;
INSERT INTO order_header VALUES (1432,50,'2024-01-20 05:28', NULL);
INSERT INTO order_detail VALUES (1432,1012,4,13.67);
INSERT INTO order_detail VALUES (1432,1020,1,15.51);
INSERT INTO order_detail VALUES (1432,1003,4,16.99);
INSERT INTO order_detail VALUES (1432,1022,2,34.78);
UPDATE order_header SET total = 207.71 WHERE order_id = 1432;
INSERT INTO order_header VALUES (1433,113,'2023-12-15 13:07', NULL);
INSERT INTO order_detail VALUES (1433,1012,1,13.67);
INSERT INTO order_detail VALUES (1433,1003,4,11.21);
INSERT INTO order_detail VALUES (1433,1002,1,7.89);
INSERT INTO order_detail VALUES (1433,1024,4,33.31);
INSERT INTO order_detail VALUES (1433,1011,3,3.67);
INSERT INTO order_detail VALUES (1433,1020,1,18.36);
UPDATE order_header SET total = 229.01 WHERE order_id = 1433;
INSERT INTO order_header VALUES (1434,31,'2023-06-01 19:39', NULL);
INSERT INTO order_detail VALUES (1434,1022,4,34.78);
INSERT INTO order_detail VALUES (1434,1001,2,7.89);
UPDATE order_header SET total = 154.9 WHERE order_id = 1434;
INSERT INTO order_header VALUES (1435,134,'2023-10-19 10:15', NULL);
INSERT INTO order_detail VALUES (1435,1018,4,3.33);
INSERT INTO order_detail VALUES (1435,1003,3,8.98);
INSERT INTO order_detail VALUES (1435,1001,1,7.89);
INSERT INTO order_detail VALUES (1435,1011,1,3.67);
UPDATE order_header SET total = 51.82 WHERE order_id = 1435;
INSERT INTO order_header VALUES (1436,41,'2023-12-25 15:55', NULL);
INSERT INTO order_detail VALUES (1436,1020,1,18.48);
INSERT INTO order_detail VALUES (1436,1010,4,3.92);
INSERT INTO order_detail VALUES (1436,1003,1,15.98);
INSERT INTO order_detail VALUES (1436,1024,4,43.98);
INSERT INTO order_detail VALUES (1436,1022,2,27.21);
UPDATE order_header SET total = 280.48 WHERE order_id = 1436;
INSERT INTO order_header VALUES (1437,53,'2023-11-06 18:46', NULL);
INSERT INTO order_detail VALUES (1437,1011,3,3.67);
INSERT INTO order_detail VALUES (1437,1003,4,18.45);
INSERT INTO order_detail VALUES (1437,1012,4,13.67);
INSERT INTO order_detail VALUES (1437,1018,2,3.94);
UPDATE order_header SET total = 147.37 WHERE order_id = 1437;
INSERT INTO order_header VALUES (1438,131,'2024-01-24 20:11', NULL);
INSERT INTO order_detail VALUES (1438,1023,4,26.98);
INSERT INTO order_detail VALUES (1438,1002,3,6.13);
INSERT INTO order_detail VALUES (1438,1022,4,39.18);
INSERT INTO order_detail VALUES (1438,1024,2,53.7);
INSERT INTO order_detail VALUES (1438,1018,4,3.64);
INSERT INTO order_detail VALUES (1438,1003,2,8.98);
UPDATE order_header SET total = 422.95 WHERE order_id = 1438;
INSERT INTO order_header VALUES (1439,65,'2023-07-01 09:30', NULL);
INSERT INTO order_detail VALUES (1439,1001,1,7.73);
INSERT INTO order_detail VALUES (1439,1022,2,31.59);
INSERT INTO order_detail VALUES (1439,1020,4,20.87);
INSERT INTO order_detail VALUES (1439,1010,4,4.67);
INSERT INTO order_detail VALUES (1439,1018,2,3.33);
INSERT INTO order_detail VALUES (1439,1019,1,7.49);
UPDATE order_header SET total = 187.22 WHERE order_id = 1439;
INSERT INTO order_header VALUES (1440,34,'2023-08-04 06:28', NULL);
INSERT INTO order_detail VALUES (1440,1012,1,12.35);
INSERT INTO order_detail VALUES (1440,1011,1,3.67);
INSERT INTO order_detail VALUES (1440,1002,4,7.31);
INSERT INTO order_detail VALUES (1440,1001,4,7.89);
INSERT INTO order_detail VALUES (1440,1018,3,2.79);
INSERT INTO order_detail VALUES (1440,1023,4,27.69);
UPDATE order_header SET total = 195.95 WHERE order_id = 1440;
INSERT INTO order_header VALUES (1441,30,'2023-10-05 15:18', NULL);
INSERT INTO order_detail VALUES (1441,1001,1,8.88);
INSERT INTO order_detail VALUES (1441,1019,1,6.67);
INSERT INTO order_detail VALUES (1441,1002,1,7.89);
INSERT INTO order_detail VALUES (1441,1010,4,5.32);
UPDATE order_header SET total = 44.72 WHERE order_id = 1441;
INSERT INTO order_header VALUES (1442,80,'2023-07-15 20:00', NULL);
INSERT INTO order_detail VALUES (1442,1002,3,8.52);
UPDATE order_header SET total = 25.56 WHERE order_id = 1442;
INSERT INTO order_header VALUES (1443,49,'2023-08-01 13:31', NULL);
INSERT INTO order_detail VALUES (1443,1010,4,5.78);
INSERT INTO order_detail VALUES (1443,1012,2,13.67);
INSERT INTO order_detail VALUES (1443,1019,4,6.67);
INSERT INTO order_detail VALUES (1443,1024,4,46.98);
INSERT INTO order_detail VALUES (1443,1022,2,31.62);
INSERT INTO order_detail VALUES (1443,1003,2,12.78);
UPDATE order_header SET total = 353.86 WHERE order_id = 1443;
INSERT INTO order_header VALUES (1444,112,'2023-03-06 12:06', NULL);
INSERT INTO order_detail VALUES (1444,1002,1,7.89);
INSERT INTO order_detail VALUES (1444,1001,2,17.64);
INSERT INTO order_detail VALUES (1444,1024,1,43.98);
INSERT INTO order_detail VALUES (1444,1003,1,8.98);
INSERT INTO order_detail VALUES (1444,1010,2,4.67);
UPDATE order_header SET total = 105.47 WHERE order_id = 1444;
INSERT INTO order_header VALUES (1445,91,'2023-11-20 21:10', NULL);
INSERT INTO order_detail VALUES (1445,1001,3,6.48);
INSERT INTO order_detail VALUES (1445,1002,1,7.89);
INSERT INTO order_detail VALUES (1445,1018,1,4.04);
UPDATE order_header SET total = 31.37 WHERE order_id = 1445;
INSERT INTO order_header VALUES (1446,25,'2023-02-24 03:05', NULL);
INSERT INTO order_detail VALUES (1446,1001,1,15.87);
INSERT INTO order_detail VALUES (1446,1003,1,8.62);
UPDATE order_header SET total = 24.49 WHERE order_id = 1446;
INSERT INTO order_header VALUES (1447,123,'2023-06-10 01:41', NULL);
INSERT INTO order_detail VALUES (1447,1019,3,7.05);
INSERT INTO order_detail VALUES (1447,1003,1,10.07);
INSERT INTO order_detail VALUES (1447,1012,1,10.45);
INSERT INTO order_detail VALUES (1447,1020,1,18.78);
INSERT INTO order_detail VALUES (1447,1022,2,32.43);
INSERT INTO order_detail VALUES (1447,1002,2,6.46);
UPDATE order_header SET total = 138.23 WHERE order_id = 1447;
INSERT INTO order_header VALUES (1448,20,'2024-01-08 00:33', NULL);
INSERT INTO order_detail VALUES (1448,1019,4,6.67);
INSERT INTO order_detail VALUES (1448,1003,4,15.98);
INSERT INTO order_detail VALUES (1448,1010,3,5.11);
INSERT INTO order_detail VALUES (1448,1011,3,3.67);
INSERT INTO order_detail VALUES (1448,1024,1,43.98);
INSERT INTO order_detail VALUES (1448,1002,3,6.73);
UPDATE order_header SET total = 181.11 WHERE order_id = 1448;
INSERT INTO order_header VALUES (1449,102,'2023-09-07 18:07', NULL);
INSERT INTO order_detail VALUES (1449,1019,3,6.67);
INSERT INTO order_detail VALUES (1449,1022,1,41.55);
INSERT INTO order_detail VALUES (1449,1010,3,4.67);
INSERT INTO order_detail VALUES (1449,1012,3,13.67);
UPDATE order_header SET total = 116.58 WHERE order_id = 1449;
INSERT INTO order_header VALUES (1450,122,'2023-11-27 10:51', NULL);
INSERT INTO order_detail VALUES (1450,1023,3,30.75);
INSERT INTO order_detail VALUES (1450,1020,1,20.55);
INSERT INTO order_detail VALUES (1450,1018,3,3.44);
INSERT INTO order_detail VALUES (1450,1003,3,15.98);
INSERT INTO order_detail VALUES (1450,1002,1,8.29);
UPDATE order_header SET total = 179.35 WHERE order_id = 1450;
INSERT INTO order_header VALUES (1451,77,'2023-04-22 17:12', NULL);
INSERT INTO order_detail VALUES (1451,1024,4,39.02);
UPDATE order_header SET total = 156.08 WHERE order_id = 1451;
INSERT INTO order_header VALUES (1452,25,'2023-03-05 11:08', NULL);
INSERT INTO order_detail VALUES (1452,1003,4,18.71);
INSERT INTO order_detail VALUES (1452,1011,4,3.73);
INSERT INTO order_detail VALUES (1452,1012,1,10.36);
INSERT INTO order_detail VALUES (1452,1022,4,40.04);
UPDATE order_header SET total = 260.28 WHERE order_id = 1452;
INSERT INTO order_header VALUES (1453,102,'2023-06-04 12:07', NULL);
INSERT INTO order_detail VALUES (1453,1001,4,7.89);
INSERT INTO order_detail VALUES (1453,1012,1,13.67);
INSERT INTO order_detail VALUES (1453,1002,1,6.11);
UPDATE order_header SET total = 51.34 WHERE order_id = 1453;
INSERT INTO order_header VALUES (1454,11,'2023-03-13 07:38', NULL);
INSERT INTO order_detail VALUES (1454,1019,3,6.67);
UPDATE order_header SET total = 20.01 WHERE order_id = 1454;
INSERT INTO order_header VALUES (1455,15,'2023-02-26 00:37', NULL);
INSERT INTO order_detail VALUES (1455,1012,3,13.67);
UPDATE order_header SET total = 41.01 WHERE order_id = 1455;
INSERT INTO order_header VALUES (1456,106,'2023-10-27 18:59', NULL);
INSERT INTO order_detail VALUES (1456,1012,2,15.49);
INSERT INTO order_detail VALUES (1456,1003,1,10.49);
INSERT INTO order_detail VALUES (1456,1024,2,43.98);
INSERT INTO order_detail VALUES (1456,1019,2,6.67);
UPDATE order_header SET total = 142.77 WHERE order_id = 1456;
INSERT INTO order_header VALUES (1457,19,'2023-09-11 21:49', NULL);
INSERT INTO order_detail VALUES (1457,1011,3,3.67);
UPDATE order_header SET total = 11.01 WHERE order_id = 1457;
INSERT INTO order_header VALUES (1458,93,'2023-03-20 14:43', NULL);
INSERT INTO order_detail VALUES (1458,1012,1,11.37);
INSERT INTO order_detail VALUES (1458,1011,3,3.67);
INSERT INTO order_detail VALUES (1458,1018,1,3.96);
INSERT INTO order_detail VALUES (1458,1019,1,7.98);
INSERT INTO order_detail VALUES (1458,1010,2,4.61);
UPDATE order_header SET total = 43.54 WHERE order_id = 1458;
INSERT INTO order_header VALUES (1459,77,'2023-08-20 11:00', NULL);
INSERT INTO order_detail VALUES (1459,1012,1,12.78);
INSERT INTO order_detail VALUES (1459,1024,1,43.98);
INSERT INTO order_detail VALUES (1459,1018,4,2.81);
UPDATE order_header SET total = 68.0 WHERE order_id = 1459;
INSERT INTO order_header VALUES (1460,32,'2023-11-01 09:22', NULL);
INSERT INTO order_detail VALUES (1460,1019,1,6.67);
INSERT INTO order_detail VALUES (1460,1018,3,3.38);
INSERT INTO order_detail VALUES (1460,1020,3,19.91);
UPDATE order_header SET total = 76.54 WHERE order_id = 1460;
INSERT INTO order_header VALUES (1461,101,'2023-07-27 06:33', NULL);
INSERT INTO order_detail VALUES (1461,1019,1,6.68);
INSERT INTO order_detail VALUES (1461,1012,4,13.67);
INSERT INTO order_detail VALUES (1461,1003,2,17.43);
INSERT INTO order_detail VALUES (1461,1010,2,5.6);
UPDATE order_header SET total = 107.42 WHERE order_id = 1461;
INSERT INTO order_header VALUES (1462,28,'2023-01-07 09:08', NULL);
INSERT INTO order_detail VALUES (1462,1010,4,4.67);
INSERT INTO order_detail VALUES (1462,1002,4,9.15);
INSERT INTO order_detail VALUES (1462,1011,3,3.67);
INSERT INTO order_detail VALUES (1462,1024,2,43.98);
INSERT INTO order_detail VALUES (1462,1018,1,3.84);
INSERT INTO order_detail VALUES (1462,1012,3,15.27);
UPDATE order_header SET total = 203.9 WHERE order_id = 1462;
INSERT INTO order_header VALUES (1463,79,'2023-05-12 05:47', NULL);
INSERT INTO order_detail VALUES (1463,1023,1,25.77);
INSERT INTO order_detail VALUES (1463,1002,2,7.89);
INSERT INTO order_detail VALUES (1463,1001,2,12.23);
INSERT INTO order_detail VALUES (1463,1024,4,49.35);
INSERT INTO order_detail VALUES (1463,1003,2,8.98);
INSERT INTO order_detail VALUES (1463,1019,4,6.67);
UPDATE order_header SET total = 308.05 WHERE order_id = 1463;
INSERT INTO order_header VALUES (1464,133,'2023-05-21 14:44', NULL);
INSERT INTO order_detail VALUES (1464,1023,3,20.79);
INSERT INTO order_detail VALUES (1464,1002,3,7.89);
INSERT INTO order_detail VALUES (1464,1020,1,18.36);
INSERT INTO order_detail VALUES (1464,1024,3,54.3);
INSERT INTO order_detail VALUES (1464,1011,4,3.67);
INSERT INTO order_detail VALUES (1464,1001,2,6.51);
UPDATE order_header SET total = 295.0 WHERE order_id = 1464;
INSERT INTO order_header VALUES (1465,133,'2023-05-29 02:20', NULL);
INSERT INTO order_detail VALUES (1465,1002,3,7.89);
INSERT INTO order_detail VALUES (1465,1001,1,7.12);
INSERT INTO order_detail VALUES (1465,1012,4,15.95);
INSERT INTO order_detail VALUES (1465,1024,1,40.69);
INSERT INTO order_detail VALUES (1465,1019,3,6.67);
UPDATE order_header SET total = 155.29 WHERE order_id = 1465;
INSERT INTO order_header VALUES (1466,74,'2023-12-07 18:23', NULL);
INSERT INTO order_detail VALUES (1466,1018,3,3.63);
INSERT INTO order_detail VALUES (1466,1003,4,11.08);
INSERT INTO order_detail VALUES (1466,1010,1,4.67);
INSERT INTO order_detail VALUES (1466,1022,3,34.78);
INSERT INTO order_detail VALUES (1466,1011,2,3.67);
UPDATE order_header SET total = 171.56 WHERE order_id = 1466;
INSERT INTO order_header VALUES (1467,96,'2023-06-15 01:16', NULL);
INSERT INTO order_detail VALUES (1467,1001,4,7.89);
INSERT INTO order_detail VALUES (1467,1002,4,7.89);
INSERT INTO order_detail VALUES (1467,1018,4,3.37);
INSERT INTO order_detail VALUES (1467,1023,3,26.98);
INSERT INTO order_detail VALUES (1467,1024,3,42.39);
UPDATE order_header SET total = 284.71 WHERE order_id = 1467;
INSERT INTO order_header VALUES (1468,63,'2023-07-30 10:40', NULL);
INSERT INTO order_detail VALUES (1468,1023,1,26.98);
INSERT INTO order_detail VALUES (1468,1011,4,3.98);
INSERT INTO order_detail VALUES (1468,1022,4,34.78);
INSERT INTO order_detail VALUES (1468,1003,4,8.98);
UPDATE order_header SET total = 217.94 WHERE order_id = 1468;
INSERT INTO order_header VALUES (1469,20,'2023-01-29 19:53', NULL);
INSERT INTO order_detail VALUES (1469,1002,2,7.89);
INSERT INTO order_detail VALUES (1469,1024,4,52.67);
INSERT INTO order_detail VALUES (1469,1001,2,7.14);
UPDATE order_header SET total = 240.74 WHERE order_id = 1469;
INSERT INTO order_header VALUES (1470,129,'2023-01-04 00:00', NULL);
INSERT INTO order_detail VALUES (1470,1018,1,3.88);
INSERT INTO order_detail VALUES (1470,1001,4,9.57);
INSERT INTO order_detail VALUES (1470,1020,3,23.31);
INSERT INTO order_detail VALUES (1470,1003,2,8.98);
UPDATE order_header SET total = 130.05 WHERE order_id = 1470;
INSERT INTO order_header VALUES (1471,79,'2023-05-14 10:42', NULL);
INSERT INTO order_detail VALUES (1471,1003,2,8.98);
INSERT INTO order_detail VALUES (1471,1020,2,16.81);
INSERT INTO order_detail VALUES (1471,1019,1,6.67);
INSERT INTO order_detail VALUES (1471,1011,4,3.26);
INSERT INTO order_detail VALUES (1471,1018,4,3.33);
UPDATE order_header SET total = 84.61 WHERE order_id = 1471;
INSERT INTO order_header VALUES (1472,23,'2023-08-26 04:28', NULL);
INSERT INTO order_detail VALUES (1472,1022,1,34.78);
INSERT INTO order_detail VALUES (1472,1001,3,7.89);
INSERT INTO order_detail VALUES (1472,1023,4,26.98);
INSERT INTO order_detail VALUES (1472,1002,4,9.79);
UPDATE order_header SET total = 205.53 WHERE order_id = 1472;
INSERT INTO order_header VALUES (1473,55,'2023-09-14 05:54', NULL);
INSERT INTO order_detail VALUES (1473,1022,4,34.78);
INSERT INTO order_detail VALUES (1473,1003,2,18.08);
INSERT INTO order_detail VALUES (1473,1010,3,4.67);
INSERT INTO order_detail VALUES (1473,1023,1,26.98);
INSERT INTO order_detail VALUES (1473,1018,4,3.28);
UPDATE order_header SET total = 229.39 WHERE order_id = 1473;
INSERT INTO order_header VALUES (1474,94,'2023-04-03 06:30', NULL);
INSERT INTO order_detail VALUES (1474,1022,1,40.9);
INSERT INTO order_detail VALUES (1474,1003,2,17.3);
INSERT INTO order_detail VALUES (1474,1023,4,26.98);
INSERT INTO order_detail VALUES (1474,1020,4,16.26);
INSERT INTO order_detail VALUES (1474,1024,2,52.35);
UPDATE order_header SET total = 353.16 WHERE order_id = 1474;
INSERT INTO order_header VALUES (1475,103,'2023-07-16 08:45', NULL);
INSERT INTO order_detail VALUES (1475,1023,2,29.66);
INSERT INTO order_detail VALUES (1475,1012,4,14.61);
INSERT INTO order_detail VALUES (1475,1018,2,3.32);
INSERT INTO order_detail VALUES (1475,1020,3,21.05);
UPDATE order_header SET total = 187.55 WHERE order_id = 1475;
INSERT INTO order_header VALUES (1476,65,'2023-09-28 10:21', NULL);
INSERT INTO order_detail VALUES (1476,1011,3,4.09);
INSERT INTO order_detail VALUES (1476,1010,4,3.99);
UPDATE order_header SET total = 28.23 WHERE order_id = 1476;
INSERT INTO order_header VALUES (1477,115,'2023-08-31 03:16', NULL);
INSERT INTO order_detail VALUES (1477,1002,2,7.89);
INSERT INTO order_detail VALUES (1477,1003,3,8.97);
INSERT INTO order_detail VALUES (1477,1023,1,26.98);
INSERT INTO order_detail VALUES (1477,1011,3,4.26);
INSERT INTO order_detail VALUES (1477,1024,3,43.98);
UPDATE order_header SET total = 214.39 WHERE order_id = 1477;
INSERT INTO order_header VALUES (1478,42,'2023-07-19 16:10', NULL);
INSERT INTO order_detail VALUES (1478,1010,1,4.67);
INSERT INTO order_detail VALUES (1478,1002,3,7.89);
INSERT INTO order_detail VALUES (1478,1001,1,6.95);
INSERT INTO order_detail VALUES (1478,1003,3,15.98);
INSERT INTO order_detail VALUES (1478,1022,1,35.6);
INSERT INTO order_detail VALUES (1478,1020,3,18.78);
UPDATE order_header SET total = 175.17 WHERE order_id = 1478;
INSERT INTO order_header VALUES (1479,94,'2023-02-01 05:53', NULL);
INSERT INTO order_detail VALUES (1479,1019,2,5.14);
INSERT INTO order_detail VALUES (1479,1003,1,7.75);
UPDATE order_header SET total = 18.03 WHERE order_id = 1479;
INSERT INTO order_header VALUES (1480,54,'2023-08-09 03:15', NULL);
INSERT INTO order_detail VALUES (1480,1001,1,15.0);
INSERT INTO order_detail VALUES (1480,1003,2,8.65);
INSERT INTO order_detail VALUES (1480,1002,2,6.38);
INSERT INTO order_detail VALUES (1480,1010,3,4.3);
UPDATE order_header SET total = 57.96 WHERE order_id = 1480;
INSERT INTO order_header VALUES (1481,127,'2023-01-30 00:01', NULL);
INSERT INTO order_detail VALUES (1481,1018,1,2.71);
INSERT INTO order_detail VALUES (1481,1001,2,7.16);
UPDATE order_header SET total = 17.03 WHERE order_id = 1481;
INSERT INTO order_header VALUES (1482,87,'2023-12-02 09:51', NULL);
INSERT INTO order_detail VALUES (1482,1022,4,34.78);
INSERT INTO order_detail VALUES (1482,1010,3,4.67);
UPDATE order_header SET total = 153.13 WHERE order_id = 1482;
INSERT INTO order_header VALUES (1483,119,'2023-04-23 14:34', NULL);
INSERT INTO order_detail VALUES (1483,1020,4,18.78);
INSERT INTO order_detail VALUES (1483,1010,4,3.98);
INSERT INTO order_detail VALUES (1483,1001,2,7.89);
INSERT INTO order_detail VALUES (1483,1022,2,35.7);
UPDATE order_header SET total = 178.22 WHERE order_id = 1483;
INSERT INTO order_header VALUES (1484,25,'2023-07-10 08:20', NULL);
INSERT INTO order_detail VALUES (1484,1003,4,19.7);
INSERT INTO order_detail VALUES (1484,1024,1,46.39);
INSERT INTO order_detail VALUES (1484,1010,4,4.4);
INSERT INTO order_detail VALUES (1484,1019,4,5.69);
INSERT INTO order_detail VALUES (1484,1011,2,3.67);
INSERT INTO order_detail VALUES (1484,1012,1,13.67);
UPDATE order_header SET total = 186.56 WHERE order_id = 1484;
INSERT INTO order_header VALUES (1485,14,'2023-10-05 14:05', NULL);
INSERT INTO order_detail VALUES (1485,1018,1,3.33);
INSERT INTO order_detail VALUES (1485,1002,3,7.89);
INSERT INTO order_detail VALUES (1485,1024,4,48.8);
UPDATE order_header SET total = 222.2 WHERE order_id = 1485;
INSERT INTO order_header VALUES (1486,108,'2023-09-23 21:25', NULL);
INSERT INTO order_detail VALUES (1486,1001,3,7.89);
INSERT INTO order_detail VALUES (1486,1002,1,7.89);
INSERT INTO order_detail VALUES (1486,1011,3,3.21);
UPDATE order_header SET total = 41.19 WHERE order_id = 1486;
INSERT INTO order_header VALUES (1487,93,'2024-01-31 18:27', NULL);
INSERT INTO order_detail VALUES (1487,1011,1,4.52);
INSERT INTO order_detail VALUES (1487,1003,4,15.98);
INSERT INTO order_detail VALUES (1487,1024,2,45.73);
INSERT INTO order_detail VALUES (1487,1018,1,3.51);
INSERT INTO order_detail VALUES (1487,1012,3,13.67);
UPDATE order_header SET total = 204.42 WHERE order_id = 1487;
INSERT INTO order_header VALUES (1488,66,'2023-04-03 06:42', NULL);
INSERT INTO order_detail VALUES (1488,1022,1,34.9);
INSERT INTO order_detail VALUES (1488,1020,4,18.78);
INSERT INTO order_detail VALUES (1488,1003,1,8.98);
UPDATE order_header SET total = 119.0 WHERE order_id = 1488;
INSERT INTO order_header VALUES (1489,39,'2023-02-01 02:27', NULL);
INSERT INTO order_detail VALUES (1489,1010,1,4.67);
INSERT INTO order_detail VALUES (1489,1023,2,27.93);
INSERT INTO order_detail VALUES (1489,1011,4,3.54);
INSERT INTO order_detail VALUES (1489,1018,3,3.04);
INSERT INTO order_detail VALUES (1489,1003,3,8.57);
INSERT INTO order_detail VALUES (1489,1020,3,23.23);
UPDATE order_header SET total = 179.21 WHERE order_id = 1489;
INSERT INTO order_header VALUES (1490,89,'2023-01-16 18:03', NULL);
INSERT INTO order_detail VALUES (1490,1018,1,3.33);
INSERT INTO order_detail VALUES (1490,1019,2,8.33);
UPDATE order_header SET total = 19.99 WHERE order_id = 1490;
INSERT INTO order_header VALUES (1491,20,'2023-02-09 17:40', NULL);
INSERT INTO order_detail VALUES (1491,1002,3,9.22);
INSERT INTO order_detail VALUES (1491,1023,3,26.98);
UPDATE order_header SET total = 108.6 WHERE order_id = 1491;
INSERT INTO order_header VALUES (1492,52,'2023-05-05 15:43', NULL);
INSERT INTO order_detail VALUES (1492,1018,3,3.33);
INSERT INTO order_detail VALUES (1492,1003,2,8.62);
INSERT INTO order_detail VALUES (1492,1010,2,4.67);
UPDATE order_header SET total = 36.57 WHERE order_id = 1492;
INSERT INTO order_header VALUES (1493,41,'2024-02-02 12:10', NULL);
INSERT INTO order_detail VALUES (1493,1002,2,7.89);
INSERT INTO order_detail VALUES (1493,1022,2,34.78);
INSERT INTO order_detail VALUES (1493,1003,4,7.28);
INSERT INTO order_detail VALUES (1493,1001,3,7.89);
UPDATE order_header SET total = 138.13 WHERE order_id = 1493;
INSERT INTO order_header VALUES (1494,101,'2023-08-29 21:47', NULL);
INSERT INTO order_detail VALUES (1494,1010,2,4.8);
INSERT INTO order_detail VALUES (1494,1011,3,4.4);
INSERT INTO order_detail VALUES (1494,1020,3,18.78);
INSERT INTO order_detail VALUES (1494,1001,1,7.89);
INSERT INTO order_detail VALUES (1494,1018,1,4.03);
INSERT INTO order_detail VALUES (1494,1003,4,15.98);
UPDATE order_header SET total = 154.98 WHERE order_id = 1494;
INSERT INTO order_header VALUES (1495,90,'2023-08-19 14:04', NULL);
INSERT INTO order_detail VALUES (1495,1001,4,13.4);
INSERT INTO order_detail VALUES (1495,1022,3,34.78);
INSERT INTO order_detail VALUES (1495,1002,1,7.86);
INSERT INTO order_detail VALUES (1495,1012,1,13.67);
INSERT INTO order_detail VALUES (1495,1003,4,8.46);
INSERT INTO order_detail VALUES (1495,1010,2,4.67);
UPDATE order_header SET total = 222.65 WHERE order_id = 1495;
INSERT INTO order_header VALUES (1496,15,'2024-01-12 18:25', NULL);
INSERT INTO order_detail VALUES (1496,1024,4,52.45);
INSERT INTO order_detail VALUES (1496,1023,3,26.98);
INSERT INTO order_detail VALUES (1496,1020,3,18.78);
INSERT INTO order_detail VALUES (1496,1003,1,15.98);
INSERT INTO order_detail VALUES (1496,1011,3,3.13);
INSERT INTO order_detail VALUES (1496,1018,2,4.0);
UPDATE order_header SET total = 380.45 WHERE order_id = 1496;
INSERT INTO order_header VALUES (1497,132,'2023-10-04 17:19', NULL);
INSERT INTO order_detail VALUES (1497,1010,2,4.67);
INSERT INTO order_detail VALUES (1497,1001,3,7.89);
INSERT INTO order_detail VALUES (1497,1003,1,8.68);
INSERT INTO order_detail VALUES (1497,1002,3,6.46);
INSERT INTO order_detail VALUES (1497,1011,3,3.67);
UPDATE order_header SET total = 72.08 WHERE order_id = 1497;
INSERT INTO order_header VALUES (1498,24,'2023-07-01 03:18', NULL);
INSERT INTO order_detail VALUES (1498,1018,1,4.05);
UPDATE order_header SET total = 4.05 WHERE order_id = 1498;
INSERT INTO order_header VALUES (1499,111,'2023-09-24 11:50', NULL);
INSERT INTO order_detail VALUES (1499,1012,3,13.56);
INSERT INTO order_detail VALUES (1499,1002,2,7.89);
INSERT INTO order_detail VALUES (1499,1023,3,28.8);
UPDATE order_header SET total = 142.86 WHERE order_id = 1499;
INSERT INTO order_header VALUES (1500,21,'2023-09-22 14:58', NULL);
INSERT INTO order_detail VALUES (1500,1023,3,26.98);
INSERT INTO order_detail VALUES (1500,1010,2,4.67);
INSERT INTO order_detail VALUES (1500,1001,4,7.89);
INSERT INTO order_detail VALUES (1500,1011,2,3.67);
INSERT INTO order_detail VALUES (1500,1020,2,18.78);
INSERT INTO order_detail VALUES (1500,1018,4,3.55);
UPDATE order_header SET total = 180.94 WHERE order_id = 1500;
INSERT INTO order_header VALUES (1501,86,'2023-07-02 18:57', NULL);
INSERT INTO order_detail VALUES (1501,1023,1,33.14);
INSERT INTO order_detail VALUES (1501,1018,1,3.16);
INSERT INTO order_detail VALUES (1501,1003,2,8.98);
INSERT INTO order_detail VALUES (1501,1002,4,7.89);
INSERT INTO order_detail VALUES (1501,1001,4,7.89);
UPDATE order_header SET total = 117.38 WHERE order_id = 1501;


drop table tempvendor;
drop table tempcustomer;
drop table person;
drop table address;