-- Customer Table

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Carter', 'Steven', '235 Shanendoa Drive Lafayette IN 47905',
'765-366-7485', 'Scarter235@netscape.net');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Johnson', 'keven', '4777 First Street Kansas City Kansas 67473',
'848-938-7241', 'Babyboy3@aol.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('McKinny', 'Jennifer', '4839 Back Ave Jermin PA 18736',
'894-923-9891', 'Jen238@hotmail.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Smith', 'Zachary', '148 Cramer Street Seattle WA 93876',
'498-473-0384', 'zachman@hotmail.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Underwood', 'Mary', '12888 Main Street Brooklyn NY 08648',
'477-958-3488', 'marywood@aol.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Lambuth', 'Kim', '687 Logan Court Miami FL 38848',
'680-446-6713', 'lambgirl@aol.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Alison', 'Robbert', '15 Cherrycreek Rd Newport RI 48372',
'247-686-3929', 'lambgirl@aol.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Martin', 'Judy', '4i34 RR 382 Jupitor OK 43939',
'972-345-3789', 'JMartin@MSN.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Thomas', 'Sally', '3132 James Street Marion MD 42984',
'342-246-7403', 'Catsitter10@aol.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Bartin', 'Berry', '576 Blackhawk Place Jeffersonville IW 39238',
'746-192-5367', 'Baker@netscape.net');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Krammer', 'John', '332 Front Street Hangoverville GA 48573',
'883-943-9846', 'Baker@netscape.net');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('William', 'Russell', '602 Feet Street Smelltown KS 83746',
'343-804-8746', 'Badboy@hotmail.com');

INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
VALUES('Edwards', 'Carrie', '7832 Blackman Street Dallas TX 56473',
'827-580-7421', 'downtowner@hotmail.com');

-- Employee Table

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Williams', 'Willie', '3843 Happy Ave, Chilitown TX', '800-555-5932',
1, '1997-03-13', 42, 'wackywillie@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Sven', 'Harper', '54 Lord Lane, Ravenholm MI', '907-871-0602',
3, '1997-06-17', 25, 'SuperSven@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Grahm', 'Matthew', '583 Jackton ave, Yaklaba MD', '607-426-8168',
2, '1998-01-11', 30, 'GrahmMat@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Lambert', 'Daniel', '4358 Pine Tree Lane Silver Spring, MD', '240-417-4843',
2, '1998-03-31', 53, 'DannieLamb@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Gatlin', 'Lucille', '254 Roguski Road Marksville, LA', '318-240-3030',
2, '1998-05-03', 32, 'LuckyLucille@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Cummings', 'Ralph', '4663 Backwordsville, GA 19283', '695-555-9275',
4,  '1999-11-09', 42, 'Bumperpool@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Bannor', 'David', '8675 Comic Lane Hulkville, GA 19283', '658-548-5848',
2,  '2001-05-29', 37, 'thehulk@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Wayne', 'Bruce', '8675 Cave Road Gathom, NY 27374', '986-836-4809',
3,  '2003-09-19', 27, 'batman@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Henderson', 'Katherine', '2656 Pennsylvania Avenue Edison, NJ 08817', '732-393-6564',
5,  '2003-12-19', 40, 'Katherine@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Partin', 'Clement', '2804 Wetzel Lane Traverse City, MI 49686', '231-360-1811',
4,  '2004-03-03', 26, 'Clementine@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Musselman', 'Lily', ' 1128 Short Street Austin, TX 78741 ', '512-874-8677',
5,  '2005-07-13', 23, 'Lilypadd@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Land', 'Angela', '4772 Richards Avenue Los Banos, CA 93635', '209-826-8641',
5,  '2007-07-13', 21, 'AngelLand@herbiesballonland.com');

INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
VALUES('Jones', 'Katherine', '3409 Norma Lane Shreveport, LA 71101', '318-588-7908',
2,  '2009-07-13', 23, 'KatieJones@herbiesballonland.com');

-- Product Table

INSERT INTO Product (Name, Price) VALUES('260 Animal Balloon', 7.35);

INSERT INTO Product (Name, Price) VALUES('160 Animal Balloon' ,  9.35);

INSERT INTO Product (Name, Price) VALUES('Dart  Balloon',  7.35);

INSERT INTO Product (Name, Price) VALUES('6in. round Balloon' ,  11.95);

INSERT INTO Product (Name, Price) VALUES('9in. round Balloon' ,  13.95);

INSERT INTO Product (Name, Price) VALUES('13in. round Balloon' ,  16.95);

INSERT INTO Product (Name, Price) VALUES('9in. square Balloon' ,  11.95);

INSERT INTO Product (Name, Price) VALUES('6in. square Balloon' ,  8.95);

INSERT INTO Product (Name, Price) VALUES('6in. Mylar Balloon' ,  12.95);

INSERT INTO Product (Name, Price) VALUES('9in. Mylar Balloon' ,  15.95);

INSERT INTO Product (Name, Price) VALUES('14in. Mylar Balloon', 17.95);

INSERT INTO Product (Name, Price) VALUES('6in. Heart Balloon', 5.95);

INSERT INTO Product (Name, Price) VALUES('9in. Heart Balloon', 7.95);

-- Transaction Table

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES(1, 10, ‘2010-10-05’);

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 3, 6, '2010-09-14');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 7, 13, '2010-04-17');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 2, 4, '2010-01-23');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 3, 8, '2010-01-23');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 9, 4, '2010-07-19');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 12, 11, '2010-03-04');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 8, 7, '2010-06-09');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 5, 7, '2010-12-10');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 10, 7, '2010-11-11');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 4, 9, '2010-07-16');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES(12, 3, '2010-02-12');

INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES(8, 1, '2010-05-14');

-- Position Table Entries

INSERT INTO Position (Title, PayRate) VALUES('CEO', 25.00);

INSERT INTO Position (Title, PayRate) VALUES('Phone Operator', 10.25);

INSERT INTO Position (Title, PayRate) VALUES('Warehouse Manager', 15.75);

INSERT INTO Position (Title, PayRate) VALUES('Office Manager', 15.25);

INSERT INTO Position (Title, PayRate) VALUES('Order Picker', 8.50);

-- LineItem Table Entries

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(3, 3 * (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 3), 1, 3);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(2, 2 * (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 5), 1, 5);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(1, 1* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 7), 2, 7);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(10, 10* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 4), 3, 4);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(4, 4* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 5), 3, 5);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(100, 100* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 2), 4, 2);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(1, 1* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 3), 5, 3);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(99, 99* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 4), 6, 4);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(200, 200* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 6), 7, 6);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(30, 30* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 12), 8, 12);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(10, 10* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 4), 9, 4);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(1, 1* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 4), 10, 4);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(10, 10* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 10), 11, 10);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(10, 10* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 5), 11, 5);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(100, 100* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 4), 12, 4);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(50, 50* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 5), 12, 5);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(50, 50* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 5), 12, 5);

INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
VALUES(10000, 10000* (SELECT Product.Price FROM Product
WHERE Product.PRODUCT_ID = 5), 13, 5);