Please provide SQL statements compatible with Oracle. (50 points) 1. List the product number, product name, and product manufacturer of products whose price is between $10.00 and $200.00 and whose next shipping date is in February of 2017. 2. Create a relation containing the customer name (first and last), and customer zip code of Colorado customers who have placed one or more orders in January 2017 and whose balance is greater than or equal to $200. Remove duplicate rows from the result. 3. Create a relation showing the employee name (first and last), and street address of employees whose last name starts with J and who have taken orders in January 2017 from WA customers in Seattle. Remove duplicate rows in the result. 4. Creating a relation showing the order number and total amount for orders placed on January of 2017. The total amount of an order is the sum of the quantity times the product price of each product on the order. 5. Create a relation showing the product name, sum of the quantity of products ordered, and total order amount (sum of the product price times the quantity) for orders placed in February 2017. Only include products that have more than three products ordered in February 2017. Sort the result in descending order of the total amount. Chapter 4 Query Formulation with SQL 131 Relationships FIGURE 4.P1 Relationship Window for the Order Entry Database Order Customer * Cust Custom Ordine Vete CustStreet Custy Cure Cup Cutsal OrdDate Custe Emotio Ordine Ord Street Ord City Ordstate ON Product Predito Predame Produto POH Pred Prodepute Emple EN Empfstand Employee gi Emprese Emple tmp Phone Supore EpConte Empta Empione Suptimplio Encomale Empwa Customer CustNo CustBal Gordon $230.00 $200.00 C0954327 C1010398 C2388597 C3340959 C3499503 C8543321 C8574932 C8654390 C9128574 C9403348 C9432910 C9543029 C9549302 C9857432 C9865874 C9943201 CustFirstName CustLastName CustStreet CustCity Sheri 336 Hill St. Littleton Jim Glussman 1432 E. Ravenna Denver Beth Taylor 2396 Rafter Rd Seattle Betty Wise 4334 153rd NW Seattle Bob Mann 1190 Lorraine Cir. Monroe Ron Thompson 789 122nd St. Renton Wally Jones 411 Webber Ave. Seattle Candy Kendall 456 Pine St. Seattle Jerry Wyatt 16212 123rd Ct. Denver Mike Boren 642 Crest Ave. Englewood Larry Styles 9825 S. Crest Lane Bellevue Sharon Johnson 1223 Meyer Way Fife Todd Hayes 1400 NW 88th Lynnwood Homer Wells 123 Main St. Seattle Mary Hill 206 McCaffrey Littleton Harry Sanders 1280 S. Hill Rd. Fife CustState Custzip 80129-5543 CO 80111-0033 WA 98103-1121 WA 98178-3311 WA 98013-1095 WA 98666-1289 WA 98105-1093 WA 98105-3345 CO 80222-0022 $500.00 $200.00 $0.00 $85.00 $1,500.00 $50.00 $100.00 $0.00 $250.00 CO WA WA 80113-5431 98104-2211 98222-1123 98036-2244 98105-4322 80129-5543 98222-2258 $856.00 $0.00 WA WA CO $500.00 $150.00 $1,000.00 WA OrderTbl OrdNo 01116324 01231231 01241518 01455122 01579999 01615141 01656777 02233457 02334661 OrdDate CustNo EmpNo OrdName OrdStreet Ord City OrdState OrdZip 01/23/2017 C0954327 E8544399 Sheri Gordon 336 Hill St. Littleton CO 80129-5543 01/23/2017 09432910 E9954302 Larry Styles 9825 S. Crest Lane Bellevue WA 98104-2211 02/10/2017 09549302 Todd Hayes 1400 NW 88th Lynnwood WA 98036-2244 01/09/2017 C8574932 E9345771 Wally Jones 411 Webber Ave. Seattle WA 98105-1093 01/05/2017 C9543029 E8544399 Tom Johnson 1632 Ocean Dr. Des Moines WA 98222-1123 01/23/2017 08654390 E8544399 Candy Kendall 456 Pine St. Seattle WA 98105-3345 02/11/2017 C8543321 Ron Thompson 789 122nd St. Renton WA 98666-1289 01/12/2017 C2388597 E9884325 Beth Taylor 2396 Rafter Rd Seattle WA 98103-1121 01/14/2017 C0954327 E1329594 Mrs. Ruth Gordon 233 S. 166th Seattle WA 98011 132 Part 2 Understanding Relational Databases OrdNo 03252629 03331222 03377543 04714645 05511365 06565656 07847172 07959898 07989497 08979495 09919699 OrdDate CustNo EmpNo OrdName OrdStreet Ord City OrdState Ordzip 01/23/2017 C9403348 E9954302 Mike Boren 642 Crest Ave. Englewood CO 80113-5431 01/13/2017 C1010398 Jim Glussman 1432 E. Ravenna Denver 80111-0033 01/15/2017 C9128574 E8843211 Jerry Wyatt 16212 123rd Ct. Denver 80222-0022 01/11/2017 C2388597 E1329594 Beth Taylor 2396 Rafter Rd Seattle WA 98103-1121 01/22/2017 C3340959 E9884325 Betty White 4334 153rd NW Seattle WA 98178-3311 01/20/2017 C9865874 E8843211 Mr. Jack Sibley 166 E. 344th Renton WA 98006-5543 01/23/2017 C9943201 Harry Sanders 1280 S. Hill Rd. Fife WA 98222-2258 02/19/2017 C8543321 E8544399 Ron Thompson 789 122nd St. Renton WA 98666-1289 01/16/2017 C3499503 E9345771 Bob Mann 1190 Lorraine Cir. Monroe WA 98013-1095 01/23/2017 09865874 HelenSibley 206 McCaffrey Renton WA 98006-5543 02/11/2017 C9857432 E9954302 Homer Wells 123 Main St. Seattle WA 98105-4322 Employee EmpNo SupEmpNo EmpCommRate E1329594 E8544399 E8843211 EmpFirstName EmpLastName EmpPhone EmpEMail Landi Santos (303) 789-1234 LSantos@bigco.com Joe Jenkins (303) 221-9875 JJenkins@bigco.com Amy Tang (303) 556-4321 ATang@bigco.com Colin White (303) 221-4453 CWhite@bigco.com Thomas Johnson (303) 556-9987 TJohnson@bigco.com Mary Hill (303) 556-9871 MHill@bigco.com Beck (720) 320-2234 TBeck@bigco.com E8843211 E8843211 E9884325 E9884325 0.02 0.02 0.04 0.04 0.05 0.02 E9345771 E9884325 E9954302 E9973110 E8843211 E9884325 Theresa Product ProdNo ProdName ProdMfg ProdQOH ProdPrice ProdNextShipDate 12 2/20/2017 2/20/2017 10 5 1/22/2017 100 P0036566 PO036577 P1114590 P1412138 P1445671 P1556678 P3455443 P4200344 P6677900 P9995676 33 17 inch Color Monitor ColorMeg, Inc. 19 inch Color Monitor ColorMeg, Inc. R3000 Color Laser Printer Connex 10 Foot Printer Cable Ethlite 8-Outlet Surge Protector Intersafe CVP Ink Jet Color Printer Connex Color Ink Jet Cartridge Connex 36-Bit Color Scanner - UV Components Black Ink Jet Cartridge Connex Battery Back-up System Cybercx $169.00 $319.00 $699.00 $12.00 $14.99 $99.00 $38.00 8 1/22/2017 24 1/22/2017 1/29/2017 16 44 $199.99 $25.69 $89.00 12 2/1/2017 OrdLine Ord No ProdNo Qty 01116324 01231231 01231231 P1445671 P0036566 P1445671 1 1 Chapter 4 Query Formulation with SQL 133 OrdNo ProdNo Qty 1 1 1 01241518 01455122 01579999 01579999 01579999 1 1 1 1 01615141 1 1 1 01615141 01615141 01656777 01656777 1 1 02233457 1 02233457 1 1 1 1 02334661 02334661 02334661 03252629 03252629 03331222 03331222 1 1 PO036577 P4200344 P1556678 P6677900 P9995676 P0036566 P1445671 P4200344 P1445671 P1556678 P0036577 P1445671 P0036566 P1412138 P1556678 P4200344 P9995676 P1412138 P1556678 P3455443 P1445671 P9995676 P0036566 P9995676 P1412138 P1445671 P1556678 P3455443 P6677900 P0036566 P1556678 P6677900 P1412138 P1556678 P3455443 1 1 1 1 03331222 03377543 03377543 04714645 1 1 04714645 1 1 1 1 1 1 1 10 1 1 5 5 5 05511365 05511365 05511365 05511365 05511365 06565656 07847172 07847172 07959898 07959898 07959898 07959898 07989497 07989497 07989497 08979495 08979495 08979495 09919699 09919699 09919699 5 5 2 P6677900 P1114590 P1412138 P1445671 2 3 1 1 P1114590 P1412138 P1445671 P0036577 1 1 1 P1114590 1 P4200344 1