I need help with these queries #s 6, 7, 8, 9, 13. Heres all the information! Thank you so much!
Product OrdLine Customer CustNo CustFirstName CustLastName CustStreet CustCity CustState Custzip CustBal OrdNo Prodo Qty ProdName ProdMtg ProdQOH ProdPrice ProdNextShipDate OrderTbl OrdDate CustNo EmpNo OrdName OrdStreet OrdCity OrdState OrdZip Employee EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate EmpEmail EmpNo EmpFirstName EmplastName EmpPhone SupEmpNo EmpCommRate EmpEmail 13. Using a Type II nested query, list the employee number, first name, and last name of employees in the (720) area code who have not taken orders. An employee is in the (720) area code if the employee phone number contains the string (720) in the beginning of the column value. Customer CustFirstName CustL astName Sheri CustStreet CustCity CustState CustZip CustBal Littleton cO 336 Hill St. 1432 E. Ravenna 2396 Rafter Rd 4334 153rd NW 1190 Lorraine Cir. Monroe WA 789 122nd St. 411 Webber Ave 456 Pine St 16212 123rd Ct 642 Crest Ave. 9825 S. Crest Lane Bellevue WA 1223 Meyer Way Gordon Glussmarn Taylor 80129-5543 80111-0033 $200.00 98103-1121 98178-3311 98013-109S 98666-1289 98105-1093 $1,500.00 500.00 9 Betty $200.00 Thompson Jones Kendall 85.00 Seattle 4932 Wally Seattle WA98105-334 S50.00 $0.00 $250.00 Denver 80222-022$100.00 23574 Jery 348 Mike 80113-5431 98104-2211 98222-1123 Boren Englewood CO 856.00 S0.00 3029 |Sharon Johnson Lynnwood WA Seattle 1400 NW 88th 23 Main St 206 McCaffrey 1280 S. Hill Rd 98036-2244 98105-4322 80129-5543 98222-2258 1,000.00 500.00 432 Homer Wells S150.00 OrderTbl OrdName CastNo EmpNo OrdNo OrdDate 01116324 OrdStreet 232013 C0954327 E8544399 Sheri Gordon 336 Hll S 0123/2013 C9432910E9954302 Larry Styles 9825 S Crest Bellee WA OrdCity OrdStateOrdZip Littleton cO 80129-5543 98104-2211 Lane Todd Hayes 40 NW 88th Lynnwood WA98036-2244 0/2013 C8574932 E9345771 Wally Jones 411 Webber Ave. Seattle WA98105-1093 141518 02/102013 9549302 01485122 01/092 57999 01052013 C543029 E8S44399 Tom Johnson 1632 Ocean Dr Des Moines WA 98222-1123 in Seatle WA 98105-848 01615141 01232013 C8654390 E3$43 Cady Kedall Ron Thompson 789 122nd St. Re Renton 98666-12 01656777 02/11/2013 C8543321 02233457 01/12/2013 C2388597 E9884325 Beth Taylor 2396 Rafter Rd Seattle WA 02334661 01/14/2013 C0954327 E1329594 Mrs. Ruth 233 S. 166th Seattle WA 98011 Gordon 01/23/2013 C9403348 E9954302 Mike Boren 642 Crest Ave 03331222 01/13/2013 CI010398 im Glussman 1432 E. Ravenna Denver CO801114 0337543 01152013 C9128574 E8843211 Jerry Wyatt 16212 123rd Ct. DenverCO8022-42 04714645 01/1/2013 2388597 E1329594 Beth Taylor 2396 Rafer Rd SeatleWA98103-12 OSS11365 | 01/22/2013 | C3310959 | E9884325 | Betty white 14334 153rd NwlSeattle |WA |98mm 066566 0120/2013 C9865874 E8843211 Mr. Jack Sibley 166 E. 344th Rent 07847172 01/23/2013 C9943201 07959898|0219201 3|C8543321|E854099| Ron lhompson | 789122nd St | Renton | WA |98166 |2s 07989497 01/162013 C3499503 E9345771 Bob Mann 08979495 01/23/2013 C9865874 WA 9806-5481 Harry Sanders 1280 S. Hill Rd.Fife WA 98222-225 1190 Lorraine Cir. Monroe WA 98013-10 HelenSibley 206 McCaffreyRentoWA 980-5s6 98006-550 099194699 02112013 9857432 E954302 Homer Wells 123 Main St Seattle WA 98105-432 Employee EmpNo EmpFirstName EmplastName EmpPhone 1329594 Landi E8544399 Joe E8843211 Amy 9345771 Colin E9884325 Thomas 9954302 Mary EmpEMail SupEmpNo EmpCommRat 0.02 002 004 004 005 002 Santos (303) 789-1234 LSantos@bigco.com E8843211 Jenkins(303) 221-9875 JJenkins@bigco.com E8843211 Tang (303) 556-4321 ATang@bigco.com E9884325 White Johnson Hill Beck (303) 221-4453 CWhite@bigco.com E9884325 (303) 556-9987 TJohnson@bigco.com (303) 556-9871 MHill@bigco.com 720) 320-2234 TBeck@bigco.comE988432 E8843211 9973110 Theresa Product ProdName ProdMfg ProdQOH ProdPrice ProdNextShipDate ProdNo P0036566 17 inch Color Monitor P0036577 19 inch Color Monitor P1114590 R3000 Color Laser Printer P1412138 10 Foot Printer Cable P1445671 8-Outlet Surge Protector P1556678 CVP Ink Jet Color Printer P3455443 Color Ink Jet Cartridge P4200344 36-Bit Color Scanner P6677900 Black Ink Jet Cartridge P9995676Battery Back-up System ColorMeg. Inc ColorMeg, Inc. Connex Ethlite Intersafe $169.00 319.00 5699.00 $12.00 $14.99 $99.00 $38.00 16 $199.99 25.69 $89.00 12 2/20/2013 2/20/2013 1/22/2013 10 100 Connex 1/22/2013 1/22/2013 1/29/2013 Connex UV Components Connex Cyberex 24 12 2/1/2013 OrdLine OrdNo 01116324 P1445671 01231231 P0036566 01231231 P144567 01241518 P0036577 01455122 P4200344 01579999 P1556678 01579999 P6677900 01579999 9995676 01615141 PO036566 01615141 P144567 01615141 P4200344 01656777 P1445671 01656777 P1556678 02233457 P0036577 02233457 P1445671 02334661 P0036566 02334661 P1412138 02334661 P1556678 03252629 P4200344 03252629 P9995676 03331222 P1412138 03331222 P1556678 03331222 P3455443 03377543 P1445671 03377543 P9995676 04714645 P0036566 04714645 P9995676 05511365 P1412138 05511365 P1445671 0S511365 P1556678 05511365 P3455443 05511365 P6677900 06565656 P0036566 ProdNo
