Untitled

create table Suppliers ( --popylneno
   supplier_id int NOT NULL PRIMARY KEY,
   supplier_name varchar(255),
   supplier_phone varchar(10),
   supplier_email varchar(255),
   other_details text
);

INSERT INTO Suppliers (supplier_id, supplier_name, supplier_phone, supplier_email,other_details)
VALUES (305,'Speedy Express','0888951214','speedyexpress@speedyexpress.com','');
INSERT INTO Suppliers (supplier_id, supplier_name, supplier_phone, supplier_email,other_details)
VALUES (306,'United Package','0888951215','unitedpackage@unitedpackage.com','');


Select * from Suppliers


create table Employees ( --popylneno
  employee_id int NOT NULL PRIMARY KEY,
  employee_fname varchar(50),
  employee_lname varchar(50),
  employee_phone varchar(10),
  other_employee_details text
);

INSERT INTO Employees (employee_id, employee_fname,employee_lname, employee_phone, other_employee_details)
VALUES (10,'Viktor','Dimitrov','0895785661','');
INSERT INTO Employees (employee_id, employee_fname,employee_lname, employee_phone, other_employee_details)
VALUES (11,'Ivan','Georgiev','0895785662','');
INSERT INTO Employees (employee_id, employee_fname,employee_lname, employee_phone, other_employee_details)
VALUES (12,'Petyr','Petrov','0895785663','');
INSERT INTO Employees (employee_id, employee_fname,employee_lname, employee_phone, other_employee_details)
VALUES (13,'Stoqn','Stoqnov','0895785664','');
INSERT INTO Employees (employee_id, employee_fname,employee_lname, employee_phone, other_employee_details)
VALUES (14,'Yordan','Stoqnov','0895785665','');


Select * from Employees


create table Addresses ( --popylneno
   address_id int NOT NULL PRIMARY KEY,
   steet varchar(50),
   city varchar(20),
   country varchar(20),
);

INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2001,'Vasil Levski #12','Sofia','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2002,'Vasil Levski #14','Sofia','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2003,'Vasil Levski #55','Sofia','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2004,'Vitoshka #44','Sofia','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2005,'Vitoshka #11','Sofia','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2006,'Vitoshka #77','Sofia','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2007,'Aleksandrovska #2','Ruse','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2008,'Aleksandrovska #6','Ruse','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2009,'Aleksandrovska #15','Ruse','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2010,'Slavqnska #3','Plovdiv','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2011,'Slavqnska #33','Plovdiv','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2012,'Slavqnska #29','Plovdiv','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2013,'Slavqnska #3','Plovdiv','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2014,'Panayot Hitov #25','Sliven','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2015,'Panayot Hitov #37','Sliven','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2016,'Panayot Hitov #1','Sliven','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2017,'Novo selo #13','Sliven','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2018,'Peyo Yavorov #6','Aitos','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2019,'Peyo Yavorov #21','Karnobat','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2020,'Geo Milev #55','Burgas','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2021,'Geo Milev #48','Burgas','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2022,'Geo Milev #12','Burgas','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2023,'Trakia #13','Varna','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2024,'Trakia #66','Varna','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2025,'Trakia #4','Varna','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2026,'Ivan Vazov #3','Stara Zagora','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2027,'Ivan Vazov #12','Stara Zagora','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2028,'Ivan Vazov #6','Stara Zagora','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2029,'Hristo Botev #46','Blagoevgrad','Bulgaria');
INSERT INTO Addresses (address_id, steet, city,country)
VALUES (2030,'Hristo Botev #19','Blagoevgrad','Bulgaria');


create table Product_types ( --popylneno
   product_type_id int NOT NULL PRIMARY KEY,
   product_name varchar(50),
);

INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10001,'Apple mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10002,'Samsung mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10003,'Lenovo mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10004,'Nokia mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10005,'Sony  mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10006,'Blackberry mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10007,'Asus  mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               ( 10008,'Huawei mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10009,'Motorola mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10010,'LG mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10011,'Xiaomi mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10012,'Panasonic mobile phones');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10013,'Huawei Smartwatches');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10014,'Samsung Smartwatches');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10015,'Acer Laptops');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10016,'ASUS Laptops');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10017,'Samsung Laptops');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10018,'Lenovo Laptops');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10019,'Razer Laptops');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10020,'Samsung Tablets');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10021,'Apple Tablets');
INSERT INTO Product_types (product_type_id, product_name )
VALUES               (10022,'Apple Smartwatches');

Select * from Product_types

create table Products ( --popylneno
   product_id int NOT NULL PRIMARY KEY,
   product_name varchar(255),
   supplier_id int FOREIGN KEY REFERENCES Suppliers(supplier_id),
   product_type int FOREIGN KEY REFERENCES Product_types(product_type_id),
   product_price money
);

INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5441,         'Apple iPhone XR' ,305,10001, 899);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5442,         'Apple iPhone XS' , 306,10001, 1349);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5443,         'Apple iPhone 8' , 306,10001, 849 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5445,         'Apple iPhone X' , 306,10001, 1149);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5446,         'Samsung Galaxy A9' , 306, 10002, 549);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price)
VALUES               (5447,         'Samsung Galaxy J4+' ,306,10002, 244 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5448,         'Samsung Galaxy A6s' ,        306, 10002, 422 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5449,         'Samsung A9 Star' ,        305, 10002, 710);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5450,         'Lenovo Z5 Pro' ,        306,10003, 488 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price)
VALUES               (5451,         'Lenovo K5 Pro' ,        306, 10003, 244);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price)
VALUES               (5452,         'Lenovo K5s' ,        306, 10003, 199);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price)
VALUES               (5453,         'Lenovo S5 Pro ' ,        306,  10003, 311);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price)
VALUES               (5454,         'Nokia X7' ,        305,10004, 444);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5455,         'Nokia 3.1 Plus' ,        306,  10004, 255 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5456,         'Nokia 7.1' ,        305, 10004, 555);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5457,         'Nokia X5' ,        306, 10004, 222);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5458,         'Sony Xperia XZ3' ,        306, 10005, 1422);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5459,         'Sony Xperia XA2 Plus' ,        305,10005, 733);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5460,         'Sony Xperia XZ2 Premium' ,        306, 10005, 1444 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5461,         'Blackberry KEY2 LE' ,        305, 10006, 666 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5462,         'Blackberry EvolveX' ,        306,   10006, 777 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5463,         'Blackberry Aurora' ,        306,     10006, 388 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5463,         'Blackberry Motion' ,        305,        10006, 666);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5464,         'Asus Zenfone Max' ,        306,     10007, 166);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5465,         'Asus Zenfone Lite L1' ,        305,       10007, 133);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5466,         'Asus Zenfone Max Plus' ,        306,      10007, 399);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5467,         'Huawei Honor WaterPlay 8' ,        306,     10008, 355 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5468,         'Huawei Honor Magic 2' ,        305,      10008, 888);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5469,         'Huawei Enjoy 9 Plus' ,        306,        10008, 422);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5470,         'Huawei Enjoy Max' ,        305,       10008, 355);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5471,         'Motorola Moto P30 Note' ,        306, 10009, 444);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5472,         'Motorola One Power' ,        306, 10009, 577);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5473,         'Motorola One' ,        306,       10009, 555);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5474,         'Motorola Moto P30' ,        306,    10009, 488);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5475,         'Motorola Moto Z3' ,        306,       10009, 733);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5476,         'LG V40 ThinQ' ,        306,  10010, 1555 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5477,         'LG Q Stylus+' ,        306,    10010, 488);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5478,         'LG G7 Fit' ,        305,       10010, 555 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price)
VALUES               (5479,         'Xiaomi Mi MIX 3' ,        305,10011, 777);
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5480,         'Xiaomi Black Shark Helo' ,        306, 10011, 866 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5481,         'Panasonic P85 NXT' ,        306, 10012, 155 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5482,         'Panasonic Eluga Z1 Pro' ,        306, 10012, 388 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5483,         'Huawei WATCH GT' ,        305,   10013, 230 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5484,         'Samsung Galaxy Watch 42mm 2018' ,        306,    10014, 349 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5485,         'Apple Watch Series 4' ,        306,10022, 399 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5486,         'Apple Watch Series 3' ,        306,10022, 329 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5487,         'Samsung Gear Sport' ,        306, 10014, 399 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5488,         'Huawei Band 3 Pro' ,        306,   10013, 113 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5489,         'Acer Predator Helios 300 Gaming Laptop' ,        306, 10015, 1199 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5490,         'Acer Aspire E 15 ' ,        306,        10015, 359 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5491,         'Acer Flagship CB3-532 15.6"' ,        306,        10015, 133 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5492,         'ASUS Chromebook C202SA-YS02 11.6' ,        306,        10016, 218 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5493,         'ASUS VivoBook F510UA 15.6' ,        306,     10016, 509 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5494,         'ASUS C302CA-DHM4 Chromebook' ,        306,        10016, 474 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5495,         'Samsung Chromebook 3' ,        305,        10017, 193 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5496,         'Lenovo Ideapad 2019 15.6 HD Laptop Notebook Computer' ,        306,         10018, 309 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5497,         'ROG Zephyrus S Ultra Slim Gaming Laptop' ,        306,        10016, 1899 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5498,         '2018 Lenovo Flex 5 15.6' ,        305,        10018, 849 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5499,         '2018 Lenovo ThinkPad T480 14' ,        306,         10018, 839 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5500,         'Razer Blade 15: Worlds Smallest 15.6' ,        306,10019, 1899 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5501,         'Samsung Galaxy Tab A' ,        306,10020,  250 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5502,         'Samsung Galaxy Tab A 10.5' ,        306, 10020, 450 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5503,         'Samsung Galaxy Tab S4' ,        306,10020, 650 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5504,         'Apple iPad Pro 11-inch' ,        305,10021, 1699 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5505,         'Apple iPad Pro 12.9-inch (2018)' ,        305,10021, 1899 );
INSERT INTO Products (product_id, product_name, supplier_id, product_type,product_price )
VALUES               (5506,         'Apple iPad 9.7-inch (2018)' ,        305, 10021, 559 );


Select * from Products

create table Customers (   --popylneno
   customer_id int NOT NULL PRIMARY KEY,
   customer_fname varchar(255),
   customer_lname varchar(255),
   customer_phone varchar(20),
   customer_email varchar(255)
);

INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (301,'Dragomir','Antonov','(0913) 107-225','zeller@sbcglobal.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (302,'Vladislav','Valchev','(0778) 734-072','bdbrown@mac.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (303,'Svilen','Bukhalov','(0913) 107-225','suresh@comcast.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (304,'Tihomir','Mladenov','(0544) 842 454','saridder@me.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (305,'Hristo','Penchev','+359(0)723 363 416','webinc@yahoo.ca');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (306,'Lyutskan','Vitanov','0159 471882','budinger@me.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (307,'Zayko','Georgiev','0948 529-784','noodles@yahoo.ca');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (308,'Vezenko','Mihailov','0373061973','mrsam@gmail.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (309,'Zhelyazko','Svetkov','+359(0)137 221087','goresky@aol.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (310,'Kaloyan','Gavrilov','0641 685879','citizenl@msn.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (311,'Dako','Karapetrov','(0616) 952 115','engelen@me.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (312,'Preslava','Teodorova','(0978) 055279','mahbub@att.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (313,'Trayana','Zdravkova','0255841577','jguyer@verizon.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (314,'Plamena','Nikolova','(0774) 134403','research@me.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (315,'Branimira','Yankova','0695168677','parasite@icloud.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (316,'Assen ','Savov','(0651) 216 260','lstaf@gmail.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (317,'Bilka','Ivanova','(0322) 137 8515','hamilton@comcast.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (318,'Stoyan','Kamenov','(0599) 738 276','breegster@gmail.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (319,'Detelin','Atanasov','+359410879882','dkasak@live.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (320,'Emil','Tanev','(0653) 900-916','bulletin@yahoo.ca');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (321,'Mitko','Evgeniev','+359252691883','dburrows@comcast.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (322,'Kostadin','Iliev','(0642) 336-656','cliffski@optonline.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (323,'Krasimir ','Mihaelov','+359410879882','guialbu@msn.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (324,'Galin','Bozhidarov','+359830757245','airship@icloud.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (325,'Ventsislav','Hadjiev','(0750) 631-825','ninenine@aol.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (326,'Bogomil','Samuilov','0984 247-661','giafly@msn.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (327,'Blaga','Dimitrova','(0339) 465-680','jimmichie@verizon.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (328,'Zornitsa','Todorova','0240 723-634','heine@att.net');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (329,'Miroslava ',' Popova','(0387) 211681','kayvonf@yahoo.com');
INSERT INTO Customers(customer_id , customer_fname,customer_lname,customer_phone,customer_email )
VALUES               (330,'Nadezhda ','Dineva','8008135','notfake@gmail.com');

Select * from Customers

create table Customer_addresses ( --popylneno
   customer_address_id int NOT NULL PRIMARY KEY,
   customer_id int FOREIGN KEY REFERENCES Customers(customer_id),
   address_id int FOREIGN KEY REFERENCES Addresses(address_id)
);

INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3001,301,2001);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3002,302,2002);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3003,303,2003);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3004,304,2004);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3005,305,2005);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3006,306,2006);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3007,307,2007);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3008,308,2008);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3009,309,2009);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3010,310,2010);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3011,311,2011);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3012,312,2012);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3013,313,2013);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3014,314,2014);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3015,315,2015);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3016,316,2016);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3017,317,2017);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3018,318,2018);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3019,319,2019);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3020,320,2020);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3021,321,2021);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3022,322,2022);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3023,323,2023);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3024,324,2024);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3025,325,2025);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3026,326,2026);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3027,327,2027);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3028,328,2028);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3029,329,2029);
INSERT INTO Customer_addresses (customer_address_id, customer_id, address_id)
VALUES (3030,330,2030);

Select * from Customer_addresses

create table Orders ( --popylneno
   order_id int NOT NULL PRIMARY KEY,
   customer_id int FOREIGN KEY REFERENCES Customers(customer_id),

   order_day_date varchar(20),
);


INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7820,304,'2017-12-20');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7821,307,'2018-01-03');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7822,301,'2018-01-25');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7823,309,'2018-03-14');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7824,326,'2018-03-21');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7825,306,'2018-04-13');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7826,309,'2018-04-23');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7827,320,'2018-05-03');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7828,305,'2018-05-04');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7829,321,'2018-05-09');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7830,302,'2018-05-21');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7831,327,'2018-06-27');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7832,318,'2018-07-10');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7833,322,'2018-07-13');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7834,304,'2018-07-17');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7835,321,'2018-08-01');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7836,307,'2018-08-09');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7837,306,'2018-08-23');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7838,327,'2018-09-10');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7839,304,'2018-09-20');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7840,312,'2018-10-08');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7841,323,'2018-10-09');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7842,315,'2018-10-18');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7843,324,'2018-11-01');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7844,318,'2018-11-05');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7845,323,'2017-12-21');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7846,329,'2018-02-20');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7847,330,'2018-03-30');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7848,326,'2018-04-10');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7849,303,'2018-04-12');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7850,316,'2018-04-18');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7851,323,'21/05/2018');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7852,305,'2018-04-20');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7853,330,'2018-04-26');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7854,313,'2018-04-30');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7855,323,'2018-05-15');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7856,316,'2018-05-28');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7857,316,'09/11/2018');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7858,321,'2018-05-29');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7859,317,'2018-07-11');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7860,305,'2018-08-06');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7861,305,'2018-08-17');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7862,310,'2018-09-10');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7863,324,'2018-09-11');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7864,317,'2018-09-18');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7865,311,'2018-09-21');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7866,308,'2018-09-25');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7867,324,'2018-10-03');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7868,309,'2018-10-09');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7869,320,'2018-10-12');
INSERT INTO Orders(order_id ,customer_id,order_day_date )
VALUES               (7870,327,'2018-10-31');

Select * from Orders

create table Order_items ( --popylneno
   order_id int FOREIGN KEY REFERENCES Orders(order_id),
   product_id int FOREIGN KEY REFERENCES Products(product_id),
   quantity int
);


INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7820,5452,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7821,5492,2);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7822,5470,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7823,5506,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7824,5474,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7825,5470,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7826,5475,2);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7827,5448,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7828,5465,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7829,5450,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7830,5470,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7831,5466,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7832,5483,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7833,5463,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7834,5481,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7835,5441,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7836,5464,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7837,5505,2);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7838,5466,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7839,5459,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7840,312,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7841,5471,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7842,5497,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7843,5446,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7844,318,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7845,5491,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7846,5489,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7847,330,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7848,5496,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7849,5453,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7850,5495,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7851,5502,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7852,5487,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7853,330,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7854,5506,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7855,5484,2);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7856,5458,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7857,316,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7858,5493,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7859,5467,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7860,5470,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7861,5494,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7862,5457,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7863,5496,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7864,5443,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7865,5487,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7866,5448,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7867,5475,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7868,5466,3);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7869,5459,1);
INSERT INTO Order_items(order_id ,product_id ,quantity )
VALUES               (7870,5466,1);

Select * from Order_items


create table Deliveries ( --popylneno
  delivery_id int NOT NULL PRIMARY KEY,
  delivered_by_employee_id int FOREIGN KEY REFERENCES Employees(employee_id),
order_id int FOREIGN KEY REFERENCES Orders(order_id),
  delivery_date_time date,
  other_delivery_details text
);


INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1001,10,7820,'2017-12-22','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1002,11,7821,'2018-01-05','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1003,12,7822,'2018-01-27','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1004,13,7823,'2018-03-17','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1005,14,7824,'2018-03-23','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1006,10,7825,'2018-04-15','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1007,11,7826,'2018-04-25','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1008,12,7827,'2018-05-06','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1009,13,7828,'2018-05-06','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1010,14,7829,'2018-05-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1011,10,7830,'2018-05-23','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1012,11,7831,'2018-06-29','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1013,12,7832,'2018-07-12','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1014,13,7833,'2018-07-15','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1015,14,7834,'2018-07-19','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1016,10,7835,'2018-08-03','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1017,11,7836,'2018-08-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1018,12,7837,'2018-08-25','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1019,13,7838,'2018-09-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1020,14,7839,'2018-09-24','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1021,10,7840,'2018-10-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1022,11,7841,'2018-10-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1023,12,7842,'2018-10-20','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1024,13,7843,'2018-11-03','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1025,14,7844,'2018-11-07','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1026,10,7845,'2017-12-23','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1027,11,7846,'2018-02-22','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1028,12,7847,'2018-04-02','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1029,13,7848,'2018-04-13','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1030,14,7849,'2018-04-14','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1031,10,7850,'2018-04-20','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1032,11,7851,'2018-05-23','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1033,12,7852,'2018-04-22','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1034,13,7853,'2018-04-28','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1035,14,7854,'2018-05-02','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1036,10,7855,'2018-05-17','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1037,11,7856,'2018-05-30','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1038,12,7857,'2018-11-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1039,13,7858,'2018-05-31','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1040,14,7859,'2018-07-13','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1041,10,7860,'2018-08-08','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1042,11,7861,'2018-08-19','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1043,12,7862,'2018-09-12','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1044,13,7863,'2018-09-13','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1045,14,7864,'2018-09-21','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1046,10,7865,'2018-09-23','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1047,11,7866,'2018-09-27','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1048,12,7867,'2018-10-05','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1049,13,7868,'2018-10-11','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1050,14,7869,'2018-10-14','');
INSERT INTO Deliveries (delivery_id, delivered_by_employee_id, order_id, delivery_date_time,other_delivery_details )
VALUES (1051,10,7870,'2018-11-02','');

Select * from Deliveries