needed 24,27 problems output with each atleast 2 screenshots
needed solution for problem 24,27 using sql database with screenshoots
unable to send the attachment nor able to send multiple pictures once.please provide me email so that i can send the attachment
+ c y D Page view A Read aloud Draw Highlight amount for orders placed on January 23, 2017. The total amount of an order is the sum of the quantity times the product price of each product on the order. 24. List the customer number, customer name (first and last), the sum of the quantity of products ordered, and the total order amount (sum of the product price times the quantity) for orders placed in January 2008. Only include products in which the product name contains the string Ink Jet or Laser. Only 137 Chapter 4 Query Formulation with SQL include customers who have ordered more than two Ink Jet or Laser products in January 2017 25. List the product number, 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 January 2017. Only include products that have more than five products ordered in January 2017. Sort the result in descending order of the total amount 26. List the order number, the order date, the customer number, the customer name (first and last), the customer state, and the shipping state (OrdState) in which the customer state differs from the shipping state. 27. List the employee number, the employee name (first and last), the commission rate, the supervising employee name (first and last), and the commission rate of the supervisor. 28. List the employee number, the employee name (first and last), and total amount of commissions on orders taken in January 2017. The amount of a commission is the sum of the dollar amount of products ordered times the commission rate of the emnlovee. Customer CustNo CustFirstName CustState Custzip CustBal CO CO WA WA WA C0954327 Sheri C1010398 Jim C2388597 Beth C3340959 Betty C3499503 Bob C8543321 Ron C8574932 Wally C8654390 Candy C9128574 Jerry C9403348 Mike C0432910 Lorry C9543029 Sharon C9549302 Todd C9857432 Homer C9385874 Mary C9943201 Harry CustLastName CustStreet CustCity Gordon 336 Hill St. Littleton Glussman 1432 E. Ravenna Denver Taylor 2396 Rafter Rd Seattle Wise 4334 153rd NW Seattle Mann 1190 Lorraine Cir Monroe Thompson 789 122nd St Renton Jones 411 Webber Ave Seattle Kendall 456 Pine St Seattle Wyatt 16212 123rd CH Denver Boren 642 Crest Ave Englewood Styles 9825 S. Crest Lane Bellevue Johnson 1223 Meyer Way Fife Hayes 1400 NW Bath Lynnwood 123 Main St Seattle 206 McCaffrey Littleton Sanders 1280 S Hill Rd File WA WA WA CO WA WA WA WA WA 80129-5543 80111-0033 98103-1121 98178-3311 98013-1095 98666-1289 98105-1093 98105-3345 80222-0022 80113-5431 98104-2211 08222-1123 98036-2244 98105 4322 80129-5543 98222-2258 $230.00 $200.00 $500.00 $200.00 $0.00 $85.00 $1,500.00 $50.00 $100.00 $0.00 $250.00 $856.00 $0.00 $500.00 $150.00 $1,000.00 Wells Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail SupEmpNo EmpCommRate Landi Joe Santos Jenkins Tang E8843211 E8843211 E1329594 E8544399 E8843211 E9345771 E9884325 E9954302 E9973110 0.02 0.02 0.04 0.04 (303) 789-1234 LSantos@bigco.com (303) 221-9875 JJenkins@bigco.com (303) 556-4321 ATang@bigco.com (303) 221-4453 CWhite@bigco.com (303) 556-9987 TJohnson@bigco.com (303) 556-9871 MHill@bigco.com (720) 320-2234 TBeck@bigco.com E9884325 E9884325 White Amy Colin Thomas Mary Theresa 0.05 Johnson HAI Beck 0.02 E8843211 E9884325 Product ProdNo ProdQOH ProdNextShipDate P0036566 P0038577 P1114590 P1412138 P1445671 P1558678 P3455443 P4200344 P0677900 P9995676 2/20/2017 2/20/2017 1/22/2017 ProdName ProdMfg 17 inch Color Monitor ColorMeg, Inc. 19 inch Color Monitor ColorMeg, Inc R3000 Color Laser Printer Connex 10 Foot Printer Cable Ethio 8-Outlet Surge Protector Intorsafe 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 12 10 5 100 33 8 ProdPrice $169.00 $310.00 $899.00 $12.00 $14.90 $99.00 $38.00 $190.00 $25.60 $89.00 24 1/22/2017 1/22/2017 1/29/2017 16 44 12 2/1/2017 OrdLine OrdNo Prod No QUY 01116324 01231231 01231231 P1445671 PO036566 P1445671 + c y D Page view A Read aloud Draw Highlight amount for orders placed on January 23, 2017. The total amount of an order is the sum of the quantity times the product price of each product on the order. 24. List the customer number, customer name (first and last), the sum of the quantity of products ordered, and the total order amount (sum of the product price times the quantity) for orders placed in January 2008. Only include products in which the product name contains the string Ink Jet or Laser. Only 137 Chapter 4 Query Formulation with SQL include customers who have ordered more than two Ink Jet or Laser products in January 2017 25. List the product number, 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 January 2017. Only include products that have more than five products ordered in January 2017. Sort the result in descending order of the total amount 26. List the order number, the order date, the customer number, the customer name (first and last), the customer state, and the shipping state (OrdState) in which the customer state differs from the shipping state. 27. List the employee number, the employee name (first and last), the commission rate, the supervising employee name (first and last), and the commission rate of the supervisor. 28. List the employee number, the employee name (first and last), and total amount of commissions on orders taken in January 2017. The amount of a commission is the sum of the dollar amount of products ordered times the commission rate of the emnlovee. Customer CustNo CustFirstName CustState Custzip CustBal CO CO WA WA WA C0954327 Sheri C1010398 Jim C2388597 Beth C3340959 Betty C3499503 Bob C8543321 Ron C8574932 Wally C8654390 Candy C9128574 Jerry C9403348 Mike C0432910 Lorry C9543029 Sharon C9549302 Todd C9857432 Homer C9385874 Mary C9943201 Harry CustLastName CustStreet CustCity Gordon 336 Hill St. Littleton Glussman 1432 E. Ravenna Denver Taylor 2396 Rafter Rd Seattle Wise 4334 153rd NW Seattle Mann 1190 Lorraine Cir Monroe Thompson 789 122nd St Renton Jones 411 Webber Ave Seattle Kendall 456 Pine St Seattle Wyatt 16212 123rd CH Denver Boren 642 Crest Ave Englewood Styles 9825 S. Crest Lane Bellevue Johnson 1223 Meyer Way Fife Hayes 1400 NW Bath Lynnwood 123 Main St Seattle 206 McCaffrey Littleton Sanders 1280 S Hill Rd File WA WA WA CO WA WA WA WA WA 80129-5543 80111-0033 98103-1121 98178-3311 98013-1095 98666-1289 98105-1093 98105-3345 80222-0022 80113-5431 98104-2211 08222-1123 98036-2244 98105 4322 80129-5543 98222-2258 $230.00 $200.00 $500.00 $200.00 $0.00 $85.00 $1,500.00 $50.00 $100.00 $0.00 $250.00 $856.00 $0.00 $500.00 $150.00 $1,000.00 Wells Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail SupEmpNo EmpCommRate Landi Joe Santos Jenkins Tang E8843211 E8843211 E1329594 E8544399 E8843211 E9345771 E9884325 E9954302 E9973110 0.02 0.02 0.04 0.04 (303) 789-1234 LSantos@bigco.com (303) 221-9875 JJenkins@bigco.com (303) 556-4321 ATang@bigco.com (303) 221-4453 CWhite@bigco.com (303) 556-9987 TJohnson@bigco.com (303) 556-9871 MHill@bigco.com (720) 320-2234 TBeck@bigco.com E9884325 E9884325 White Amy Colin Thomas Mary Theresa 0.05 Johnson HAI Beck 0.02 E8843211 E9884325 Product ProdNo ProdQOH ProdNextShipDate P0036566 P0038577 P1114590 P1412138 P1445671 P1558678 P3455443 P4200344 P0677900 P9995676 2/20/2017 2/20/2017 1/22/2017 ProdName ProdMfg 17 inch Color Monitor ColorMeg, Inc. 19 inch Color Monitor ColorMeg, Inc R3000 Color Laser Printer Connex 10 Foot Printer Cable Ethio 8-Outlet Surge Protector Intorsafe 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 12 10 5 100 33 8 ProdPrice $169.00 $310.00 $899.00 $12.00 $14.90 $99.00 $38.00 $190.00 $25.60 $89.00 24 1/22/2017 1/22/2017 1/29/2017 16 44 12 2/1/2017 OrdLine OrdNo Prod No QUY 01116324 01231231 01231231 P1445671 PO036566 P1445671
