A C D L F G 1 Store and Regional Database 2 Average sales in West sales region How many items with Unit Price greater than $250 4 5 as Discount K 50% C M: N 0 P 018022 as 04 Store Sales ID 17 No. Date of Order Item No. Item Description 1 12/3/2014 2006 124inch Monta 9 2 1 12/1/2014 2005 24nch Montor Unit Price $259.95 $250 95 Sales Units Total Sold Region Revenue Hem Type Combine item No and Description 06- Expected Shipping Date 07 Discounte Unit Price Q Bonus Q1 BoQ2 New Unit Price Day of (Nested-IF) Order Eligible? $27.95 305 $20995 10 1 12/21/2014 2006 24inch Monitor $250 05 South $208.05 11 4 1 120/2014 3000 Wireless Keyboard $10.95 30 South $4095 12 6 1 12/1/2014 3000 Wireless Keyboard $19.95 35 South $5405 H 11 0 1 12/0/2014 3006 Wireless Keyboard $19.90 South 14 7 1 12/1/2014 6050 PC Mouse $896 28 South $3695 15 0 12/24/2014 6060 PC Mouse $8.95 3South $11.95 16 0 1 12/2/2014 6060 PC Mouse $8.95 38 South $46.96 17 10 1 12/5/2014 8500 10 11 12/5/2014 8500 17inch Laptop 17inch Laptop $899.99 25 South $104.50 5000.00 27 South $500 90