USING MYSQL CODE PROVIDED (Please ANSWER THESE QUESTIONS) BELOW

--INSERT INTO 'Employee' ('EmployeeId, 'Firstname','LastName')VALUES--

-

INSERT INTO Employee VALUES

('111','Kenny','Wilson');

INSERT INTO Employee VALUES

('112' ,'Wally','West');

INSERT INTO Employee VALUES

('113','Kendrick','Lamar');

INSERT INTO Employee VALUES

('222','Buster','Jones');

INSERT INTO Employee VALUES

('333','Joe','Wilson');

INSERT INTO Employee VALUES

('101','Moe','Wilson');

INSERT INTO Employee VALUES

('223','Ashley','Jackson');

INSERT INTO Employee VALUES

('100','Alex','Smith');

INSERT INTO Employee VALUES

('233','Josh','Smith');

INSERT INTO Employee VALUES

('344','John','Wall');

-

--INSERT INTO Customer1 VALUES('CustomerId,'Firstname','LastName','Phone_Number','Address' )VALUES

-

INSERT INTO Customer1 VALUES

('2320','Bradley','Jones','703-771-8877','555 Main Street Fairfax-VA');

INSERT INTO Customer1 VALUES

('1000','Michael','Jackson','703-771-9900','101 Green Circle-MD');

INSERT INTO Customer1 VALUES

('1122','Joe','Budden',571-321-4545,'321 Plain Drive-MD');

INSERT INTO Customer1 VALUES

('1001','Kobe','Bryant',202-551-8778,'300 Jones Street-VA');

INSERT INTO Customer1 VALUES

('1123','Aaron','Chen',703-717-6300,'630 Walker Lane-VA');

INSERT INTO Customer1 VALUES

('3030','Wade','Wilson',703-613-4110,'222 Burke Street-VA');

INSERT INTO Customer1 VALUES

('1055','Derrick','Walker',703-333-7474,'600 Walker Lane- MD');

INSERT INTO Customer1 VALUES

('4444','Greg','Powers',703-250-4410,'500 Main Street- VA');

INSERT INTO Customer1 VALUES

('2525','Jordan','Rodgers','202-441-6320','300 Plain Drive-VA');

INSERT INTO Customer1 VALUES

('1044','Don','Bryant',703-600-5200,'101 Rose Street-DC');

-

--INSERT INTO VALUES 'Orders1' ('OrderId','Quantity','INDate','OutDate','CustomerId','EmployeeID') VALUES

-

INSERT INTO Orders1 VALUES

('10110','2','2017-02-05','2017-02-07','1000','111');

INSERT INTO Orders1 VALUES

('11111','8','2017-04-05','2017-05-05','2320','111');

INSERT INTO Orders1 VALUES

('22222','1','2017-10-05','2017-10-10','1000','112');

INSERT INTO Orders1 VALUES

('11122','1','2017-08-05','2017-08-08','1044','113');

INSERT INTO Orders1 VALUES

('10000','3','2017-09-05','2017-010-05','4444','111');

INSERT INTO Orders1 VALUES

('33333','5','2017-07-07','2017-07-14','3030','100');

INSERT INTO Orders1 VALUES

('44455','5','2018-05-01','2017-05-05','1123','333');

INSERT INTO Orders1 VALUES

('55566','7','2017-08-05','2017-08-15','1001','101');

INSERT INTO Orders1 VALUES

('10233','9','2017-04-02','2017-04-07','2525','222');

INSERT INTO Orders1 VALUES

('11221','3','2017-04-15','2017-04-27','1000','233');

INSERT INTO Orders1 VALUES

('22442','2','2017-01-04','2017-01-14','1055','333');

INSERT INTO Orders1 VALUES

('10232','4','2017-04-25','2017-04-29','1122','112');

INSERT INTO Orders1 VALUES

('10100','6','2017-03-05','2017-03-16','3030','112');

INSERT INTO Orders1 VALUES

('38733','8','2017-02-05','2017-02-17','1001','100');

INSERT INTO Orders1 VALUES

('40044','5','2018-04-05','2017-02-05','4444','101');

INSERT INTO Orders1 VALUES

('50505','2','2018-01-02','2017-02-05','2320','233');

--INSERT INTO 'Item' ('ItemID, 'Cost', 'Info')VALUES

INSERT INTO Item VALUES('1111','$9','Shirts');

INSERT INTO Item VALUES('2222','$6','Pants');

INSERT INTO Item VALUES('3333','$12','Both');

-

-

--INSERT INTO 'Order_Line1' ('OrderID','ItemID') VALUES

INSERT INTO Order_Line1 VALUES

('10110','1111');

INSERT INTO Order_Line1 VALUES

('11111','2222');

INSERT INTO Order_Line1 VALUES

('22222','3333');

INSERT INTO Order_Line1 VALUES

('33333','1111');

INSERT INTO Order_Line1 VALUES

('55566','1111');

INSERT INTO Order_Line1 VALUES

('11111','3333');

INSERT INTO Order_Line1 VALUES

('11221','3333');

INSERT INTO Order_Line1 VALUES

('22442','3333');

INSERT INTO Order_Line1 VALUES

('10232','2222');

INSERT INTO Order_Line1 VALUES

('10100','2222');

INSERT INTO Order_Line1 VALUES

('38733','3333');

INSERT INTO Order_Line1 VALUES

('50505','1111');

INSERT INTO Order_Line1 VALUES

('44455','2222');

--------------------------------------------------------------------------------------------------------------------------------------

Screen shots of SQL queries you used to retrieve data from the tables along with the query results. For each query, explain in a complete, coherent sentence what it is intended to do, what data is expected as a result and how they are different from previous queries. Clearly identify each screen shot you paste into this section. To create queries, use the following structures 4. a. A query that is based on two tables and includes both an arithmetic and a special operator in the conditional expression. A query that is based on more than two tables and includes both an arithmetic and a special operator in the conditional expression. Both the arithmetic and the special operator must be different from the ones used in part a. A query that includes a sub-query A query that contains the GROUP BY clause, one of the aggregate functions, the WHERE statement, and the HAVING operator. Two additional complex queries designed by you that are different from the above. A complex query is based on two or more tables and includes either several conditions or a subquery (or both) b. c. d. e