Data base lab:Midterm Assignment:The database for this assignment contains data that supports a simple orderprocessing application for a small distribution company. It consists of fivetables:$1.$ The CUSTOMERS table stores data about each customer, such as thecompany name, credit limit$,$ and the salesperson who calls on thecustomer$\mathrm{.}2.$ The SALESREP table stores the employee number, name, age, year$-$to$-$date sales and other data about each salesperson$\mathrm{.}3.$ The OFFICES table stores data about each of the five sales officesincluding the city where the office is located, the sales region to which itbelongs, an so on$\mathrm{.}4.$ The ORDERS table keeps track of every order placed by a customer,identifying the salesperson who took the order $($not necessarily thesalesperson who calls on the customer$),$ the product ordered, the quantityand amount of the order, and so on$.$ For simplicity, each order is for onlyone product$\mathrm{.}5.$ The PRODUCTS table stores data about each product available for sale,such as the manufacturer, product number, description, and price.Queries:$($Unless otherwise instructed, you should assume the query is asking for names,not id numbers of customers, people, product or city offices; rename attributesif the meaning of the resultant table is not clear.$)1.$ Show the name, sales, and quota of Bill Adams$2.$ Show the total value of the inventory on hand for each product. Arrangein descending order by total value$3.$ List the offices with a target over $$600,000\mathrm{.}4.$ What is the average of all the sales people?$5.$ What is the total order size for each salesperson whose orders total morethan $$30,000?1-$Use the following code to create the data base :drop table orders;drop table products;drop table customers;drop table offices;drop table salesreps;create table ORDERS$($ORDER$\_$NUM varchar$(6)$ constraint pk$\_$orders primary key,ORDER$\_$DATA date,CUST char$(4),$REP char$(3),$MFR char$(3),$PRODUCT varchar$(10),$QTY int,AMOUNT money$)$;create table PRODUCTS$($MFR$\_$ID char$(3),$PRODUCT$\_$ID varchar$(10),$DESCRIPTION varchar$(20),$PRICE money,QTY$\_$ON$\_$HAND int,constraint pk$\_$products primary key$($MFR$\_$ID$,$ PRODUCT$\_$ID$))$;create table CUSTOMERS$($CUST$\_$NUM char$(4)$ constraint pk$\_$customers primary key,COMPANY varchar$(20),$CUST$\_$REP char$(3),$CREDIT$\_$LIMIT money$)$;create table OFFICES$($OFFICE char$(2)$ constraint pk$\_$offices primary key,CITY varchar$(20),$REGION varchar$(10),$MGR char$(3),$TARGET money,SALES money $)$;create table SalesReps$($emp$\_$num char$(3)$ constraint pk$\_$salesRep primary key,name varchar$(20),$age int,rep$\_$office char$(2),$title varchar$(10),$manager char$(3),$hire$\_$date date,quota money,sales money $)$;INSERT INTO CUSTOMERS VALUES$(\text{'}2101\text{'},$ 'Jones Mfg$.\text{'},\text{'}106\text{'},\text{'}$$$65000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2102\text{'},$ 'First Corp.$\text{'},\text{'}101\text{'},\text{'}$$$65000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2103\text{'},$ 'Acme Mfg$.\text{'},\text{'}105\text{'},\text{'}$$$50000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2105\text{'},$ 'AAA Investments',$\text{'}101\text{'},\text{'}$$$45000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2106\text{'},$ 'Fred Lewis Corp.$\text{'},\text{'}102\text{'},\text{'}$$$65000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2107\text{'},$ 'Ace International', $\text{'}110\text{'},\text{'}$$$35000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2108\text{'},$ 'Holm & Landis', $\text{'}109\text{'},\text{'}$$$55000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2109\text{'},$ 'Chen Associates', $\text{'}103\text{'},\text{'}$$$25000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2111\text{'},\text{'}$JCP Inc.$\text{'},\text{'}103\text{'},\text{'}$$$50000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2112\text{'},$ 'Zetacorp', $\text{'}108\text{'},\text{'}$$$50000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2113\text{'},$ 'Ian & Schmidt', $\text{'}104\text{'},\text{'}$$$20000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2114\text{'},$ 'Orion Corp.$\text{'},\text{'}102\text{'},\text{'}$$$20000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2115\text{'},$ 'Smithson Corp.$\text{'},\text{'}101\text{'},\text{'}$$$20000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2117\text{'},\text{'}$J$.$P$.$ Sinclair', $\text{'}106\text{'},\text{'}$$$35000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2118\text{'},$ 'Miswest Sytems', $\text{'}108\text{'},\text{'}$$$60000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2119\text{'},$ 'Solomon Inc.$\text{'},\text{'}109\text{'},\text{'}$$$25000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2120\text{'},$ 'Rico Enterprises', $\text{'}102\text{'},\text{'}$$$50000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2121\text{'},$ 'QMA Assoc.$\text{'},\text{'}103\text{'},\text{'}$$$54000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2122\text{'},$ 'Three$-$Way Lines', $\text{'}105\text{'},\text{'}$$$30000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2123\text{'},$ 'Carter & sons', $\text{'}102\text{'},\text{'}$$$40000\text{'})$;INSERT INTO CUSTOMERS VALUES$(\text{'}2124\text{'},$ 'Peter Brothers', $\text{'}107\text{'},\text{'}$$$40000\text{'})$;INSERT INTO OFFICES VALUES $(\text{'}11\text{'},$'NewYork','Eastern',$\text{'}106\text{'},\text{'}$$$575000\text{'},\text{'}$$$692637\text{'})$;INSERT INTO OFFICES VALUES$(\text{'}12\text{'},$'Chicago','Eastern',$\text{'}104\text{'},\text{'}$$$800000\text{'},\text{'}$$$735042\text{'})$;INSERT INTO OFFICES VALUES$(\text{'}13\text{'},$'Atlanta','Eastern',$\text{'}105\text{'},\text{'}$$$350000\text{'},\text{'}$$$367911\text{'})$;INSERT INTO OFFICES VALUES $(\text{'}21\text{'},$'LosAngeles','Western',$\text{'}108\text{'},\text{'}$$$725000\text{'},\text{'}$$$835915\text{'})$;INSERT INTO OFFICES VALUES$(\text{'}22\text{'},$'Denver','Western',$\text{'}108\text{'},\text{'}$$$300000\text{'},\text{'}$$$186042\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112961\text{'},\text{'}17-$Dec$-99\text{'},\text{'}2117\text{'},\text{'}106\text{'},$'REI',$\text{'}2$A$44$L$\text{'},7,\text{'}$$$31500\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112963\text{'},\text{'}17-$Dec$-99\text{'},\text{'}2103\text{'},\text{'}105\text{'},$'ACI',$\text{'}41004\text{'},28,\text{'}$$$3276\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112968\text{'},\text{'}12-$Oct$-99\text{'},\text{'}2102\text{'},\text{'}101\text{'},$'ACI',$\text{'}41004\text{'},34,\text{'}$$$3978\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112975\text{'},\text{'}12-$Oct$-99\text{'},\text{'}2111\text{'},\text{'}103\text{'},$'REI',$\text{'}2$A$44$G$\text{'},6,\text{'}$$$2100\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112979\text{'},\text{'}12-$Oct$-99\text{'},\text{'}2114\text{'},\text{'}102\text{'},$'ACI',$\text{'}4100$Z$\text{'},6,\text{'}$$$15000\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112983\text{'},\text{'}27-$Dec$-99\text{'},\text{'}2103\text{'},\text{'}105\text{'},$'ACI',$\text{'}41004\text{'},6,\text{'}$$$702\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112987\text{'},\text{'}31-$Dec$-99\text{'},\text{'}2103\text{'},\text{'}105\text{'},$'ACI',$\text{'}4100$Y$\text{'},11,\text{'}$$$27500\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112989\text{'},\text{'}03-$Jan$-00\text{'},\text{'}2101\text{'},\text{'}106\text{'},$'FEA',$\text{'}114\text{'},6,\text{'}$$$1458\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112992\text{'},\text{'}04-$Nov$-99\text{'},\text{'}2118\text{'},\text{'}108\text{'},$'ACI',$\text{'}41002\text{'},10,\text{'}$$$760\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112993\text{'},\text{'}04-$Jan$-99\text{'},\text{'}2106\text{'},\text{'}102\text{'},$'REI',$\text{'}2$A$45$C$\text{'},24,\text{'}$$$1896\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}112997\text{'},\text{'}08-$Jan$-00\text{'},\text{'}2124\text{'},\text{'}107\text{'},$'BIC',$\text{'}41003\text{'},1,\text{'}$$$652\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}113003\text{'},\text{'}25-$Jan$-00\text{'},\text{'}2108\text{'},\text{'}109\text{'},$'IMM',$\text{'}779$C$\text{'},3,\text{'}$$$5625\text{'})$;INSERT INTO ORDERS VALUES $(\text{'}113007\text{'},\text{'}08-$Jan$-00\text{'},\text{'}2112\text{'},\text{'}108\text{'},$'IMM',$\text{'}773$C$\text{'},3,\text{'}$$