Please answer number 4

4. Select the top 3 customers (show customer name) who have placed the most orders. 5. Get the name of the customer who spent the most money with our company (price qty). 6. Our company wants to raise our prices on all parts. The current prices are in three ranges (less than or equal to 199.99, greater than 199.99 but less than 365.00, and greater than 365.00 ). To get our parts all near the same price, impose a 50% increase on the first range of parts, a 30% increase on the second range, and a 10% increase on the third range. The final output the part name, the old price (original price), and the new price (showing the increase). \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Part } \\ \hline PK & PNO \\ \hline & PNAME \\ & QOH \\ & Price \\ & OLevel \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ Employee } \\ \hline PK & ENO \\ \hline & ENAME \\ & ZIP HDate Dept Salary \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Customer } \\ \hline PK & CNO \\ \hline & CNAME STREET ZIP Phone \\ \hline \end{tabular} Places CREITI THELE PNET 6 pro varchar2 (8), PnamA VAFCHARZ (50), price MUREER (6,2) CHECR ( PE.ICE >0.0), disccunt_peccent NUMBCR (5,3), olovol INTEGER TEFUNLF '20', constraint RARI_ER primary key {pno}); CRERIIZ ThLLE cusTcMER ( cno NUMER (5), cnama YAECARR2 (30), street VARCHAR2 (30), zip MIMERE [5}, phone CHA.(12), constraint cuspcM[RR_FR primary key (cno\}): CREAIT 'IABLE OKDERI ( anD MIMERE 5 S CNO MNMER ( 5 , GnD MUMERR (11), rocoived DATE, shipped DATE, congt.raint of.DFRI PK primary key \{ono\}, constraint OR.DER1_zRI forcign key (cno) references CUSTOKER(cuo), constraint of.DER1_z2Z foroign hoy (ono) roforences EMPLOYET (ENO)); CRERTI T TLELE ODEThIIS CREATE 'IABLE RARI' pno varchar2 (8), pname VARCHRR2 (50), DrICO NUMER (6,2) CCIECRSPRICE =0.0}, dizcount porcont Minger(S, 2), olevel INIEGER DEFAUL ' 20 ', congt.xaint PAFT DR primary key\{pno\}]/ CREATE TABLE COSTCMARR cno MTAEER (S), craare VARCHAR 2(30), strant VAFCHARZ(30), zip MUAER (5), phone CIAR(12), conatraint cusrcyar_TR primary koY (cno)); CREATE TARALF ORDERI I ONO MUMEER (5), CRD NUMBER (5), Ono MJMEE (11), received DAIE, shippar TATE. constraint of.DER1_IR primary key (ono), constraint 0rDER1_FRl foreign key (cno) references CUSTONER(cno), constraint oHDER1_zx2 foreign key (eno) references CREATE TABLE ODETAIIS ( ONO MTAEEE [S\}, END varchar2 (8), QTY TNTEGER CHACR (QTY > D), constraint ODETAILE_FK1 foreign key (ono) references ORDER1 (CNO), constraint ODELAIL__FK2 foreign key (pNO) references FaRM(pno))