Product OrdLine Customer ProdNo CustNo CustFirstName CustLastName CustStreet CustCity CustState CustZip CustBal OrdNo ProdNo Qty ProdName ProdMfg ProdQOH ProdPrice ProdNextShipDate OrderTbl OrdNo OrdDate CustNo EmpNo OrdName OrdStreet OrdCity OrdState OrdZip Employee Employee 1 EmpNo EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate EmpEmail EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate EmpEmail use the tables of the Order Entry database introduced in the Problems section of Chapter 4. When for- h roblems, remember that the EmpVo foreign key in the OrderTb table allows null values. An order does rulating x ave an associated employee if taken over the Internet. L Usnga Type I nested query, list the customer number, name (first and last), and city of each customer who has a bulance greater than $150 and placed an order in February 2013. 2. Using a Type Il nested query, list the customer number, name (first and last), and city of each custom a balance greater than $150 and placed an order in February 2013. Using two Type I nested queries, list the product number, the name, and the price of products with a than $150 that were ordered on January 23, 2013. 3. 4. Using two Type I nested queries and another join style, list the product number, name, and price of bhy cust a price greater than S150 that were ordered in January 2013 by customers with balances greater List the order number, order date, employce number, and employee name (first and last) of orders ary 23, 2013. List the order even if there is not an associated employee. aofordrpaced on lea 5. placed mer number, and au List the order number, order date, employee number, employee name (first and last), customer n tomer name (first and last) of orders placed on January 23, 2013. List the order even if there is not an a employee. 6. List all the people in the database. The resulting table should have all columns of the Customer tables. Match the Customer and Employee tables on first and last names. If a customer does not match ployees, the columns pertaining to the Employee table will be blank. Similarly for an employee who dos match any customers, the columns pertaining to the Customer table will be blank. and 7. For each Ink Jet product ordered in January 2013, list the order number, order date, customer num name (first and last), employee number (if present), employee name (first and last), quantity number, and product name. Include products containing Ink Jet in the product name. Include both Intenet i ber, customer 8. employee) and phone orders (taken by an employee). 9. Using a Type II nested query, list the customer number and name of Colorado customers who have not pleced orders in February 2013. Customer CustFirstNameCustL.astName CustStreet CustCity CustState Custzip CustBal Gordon 336 Hill St. 1432 E. Ravenna Denver 2396 Rafter Rd 4334 153rd NW 1190 Lorraine Cir 789 122nd St. 411 Webber Ave. 456 Pine St. 16212 123rd Ct 642 Crest Ave. 9825 S. Crest Lane BellevueWA 223 Meyer Way 1400 NW 88th 123 Main St 206 McCaffrey 1280 S. Hill Rd Ltleton CO 80129-5543 $230.00 $200.00 Glussman Seattle Monroe Renton Seattle Seattle Denver Englewood co 80111-0033 98103-1121 98178-3311 98013-1095 98666-1289 98105-1093 $1,500.00 98105-3345 $200.00 Thompson Jones Kendall Wyatt 874932 Wally $50,00 8022-0022$100.00 80113-5431 98104-2211 98222-1123 98036-2244 98105-4322 80129-5543 98222-2258 $1,000.00 $250.00 $856.00 $0.00 $500.00 S150.00 Johnson 502 Todd Lynnwood WA Seattle Hayes Littleton Sanders WA OrderTbl OrdName OrdDate CustNo Emp Ord No 116324 01/23/2013 coos 231231 01/23/2013 C9432910 OrdStreet C0954327 E8544399 Sheri Gordon 336 Hill St OrdCity OrdState OrdZip LittletonCO 80129-5543 Larry Styles 9825S.rstellee WA 98104-2211 Lane Todd Hayes 1400 NW 88th Lynnwood WA | WA 0105 2013 | C9543029 | E8544399|Torn Johnson |1632 0cean Dr. |Des Moines | WA 04118 02/10/2013 C9549302 98036-2244 | 98105-1093 L09/2013 | C8574932 | E9345771 | wally Jones | 411 webber Ave. | Seattle 98222-1123 A 98105-3345 WA-198666-1289] Seattle 01615141 01/23/2013 C8654390 E8544399 Candy Kendall 456 Pine St 01656777 02/11/2013 C8543321 02233457 01/12/2013 C2388597 E9884325 Beth Taylor 2396 Rafter Rd Seattle 0233466101/14/2013 C0954327 E1329594 Mrs. Ruth Renton Ron Thompson 789 122nd St WA 8103-112 Seatle WA 98011 233 S. 166th Gordon 03252629 01/23/2013 C9403348 E9954302 Mike Boren642 Crest Ave Englewood CO 80113. 03331222 01/13/2013 C1010398 03377543 01/15/2013 C9128574 E8843211 Jerry Wyatt 04714645 01/11/2013 C2388597 E1329594 Beth Taylor 05511365 01/22/2013 C3340959 E9884325 Betty White 4334 153rd NW Seattle 06565656 01/20/2013 C9865874 E8843211 Mr. Jack Sibley 166 E. 344th 07847172 01/23/2013 C9943201 07959898 0219/2013 C8543321 E8544399 Ron Thompson 789 122nd St. 07989497 01/16/2013 C3499503 E9345771 Bob Mann 08979495 01/23/2013 C9865874 921 9699 02/11/2013 C9857432 E9954302 Homer Wells 123 Main St Jim Glussman 1432 E. Ravenna Denver cO CO 16212 123rd Ct. Denver 2396 Rafter Rd Seattle 80111-03 80222-0022 98103-112 WA 98178-331 98006-5543 WA WA WA 1190 Lorraine Cir. Monroe WA Renton 98222-2258 98666-1289 98013-1095 98006-5543 98105-4322 Harry Sanders 1280 S. Hill Rd. Fife Renton WA 206 McCaffrey Renton Seattle WA Employee EmpNo EmpFirstName EmplastName EmpPhone E1329594 Landi E8544399 Joe E8843211 Amy E9345771 Colin E9884325 Thomas E9954302 |Mary 9973110 Theresa EmpEMail SupEmpNo EmpCommRate (303) 789-1234 LSantos@bigco.com E8843211 (303) 221-9875 JJenkins@bigco.com E8843211 (303) 556-4321 ATang@bigco.com (303) 221-4453 CWhite@bigco.com E9884325 (303) 556-9987 TJohnson@bigco.com (303) 556-9871 MHill@bigco.com (720) 320-2234 TBeck@bigco.com 0.02 002 0.04 004 005 002 Santos Jenkins E9884325 White Johnson Hill Beck E8843211 Product ProdName ProdMfg ProdQOH ProdPrice ProdNextShipDate ProdNo P0036566 17 inch Color Monitor P003657719 inch Color Monitor P1114590 R3000 Color Laser Printer P1412138 10 Foot Printer Cable PI445671 8-Outlet Surge Protector P1556678CVP Ink Jet Color Printer P3455443Color Ink Jet Cartridge P4200344 36-Bit Color Scanner P6677900 Black Ink Jet Cartridge $169.00 $319.00 $699.00 $12.00 $14.99 $99.00 $38.00 $199.99 $25.69 $89.00 12 2/20/2013 2/20/2013 1/22/2013 ColorMeg, Inc ColorMeg, Inc. Connex Ethlite Intersafe Connex Connex UV Components Connex Cybercx 10 100 1/22/2013 1/22/2013 1/29/2013 24 16 P9995676 Battery Back-up System 12 2/1/2013 OrdLine OrdNo ProdNo 01116324 P1445671 01231231 P0036566 01231231 P1445671 01241518 P0036577 01455122 P4200344 01579999 P1556678 01579999 P6677900 01579999 P9995676 01615141 P0036566 01615141 P1445671 01615141P4200344 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 O5511365 P1556678 05511365 P3455443 05511365 P6677900 06565656 P0036566 Oty 10
