Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please give the answer with function. what can i do to get the answer? 1 Sales Rep Table Product Table 2 SalesReplD FirstName LastName 3

Please give the answer with function.

image text in transcribedimage text in transcribed

what can i do to get the answer?

1 Sales Rep Table Product Table 2 SalesReplD FirstName LastName 3 SR1 Amanda Ortiz 4 SR2 Kelly O'Connor 5 SR3 Malcolm Avore 6 SR4 Ryan Janovic 7 SR5 Marissa Walker SSN 123-45-6789 234-56-7890 345-67-8901 456-78-9012 567-89-1011 Commissi on Rate 5.0% 7.0% 9.0% 12.0% 2.0% ItemID IT1 JIT2 IT3 IT4 ITS ItemName Dr. Laser $ Boomer Juice $ Bullish on Lasell $ 1851 Drink $ Zuar Sour $ Price 1.50 2.00 5.00 3.63 8.59 Address Quantity 30.0 CA 77.0 9 Order Detail Table 10 Order Detailid OrderID 11 OD1 ORD1 12 OD10 ORD6 13 OD11 ORD7 14 OD2 ORD1 15 OD3 ORD2 16 OD4 ORD3 17 ODS ORD3 18 OD6 ORD3 19 ODT ORD4 20 ODS ORD5 21 OD9 ORDS Customer Table CustID FirstName LastName 1 Adam Sandler 2 Lady Gaga 3 Mark Wahlberg 4 Meek Mill 5 Aaron Judge PA ItemID 1851 Drink Dr. Laser Bullish on Lasell Boomer Juice Bullish on Lasell Dr. Laser Zuar Sour Boomer Juice 1851 Drink Zuar Sour Boomer Juice 52.0 15.0 50.0 25.0 100.0 75.0 18.0 150.0 80.0 Customer Order Table OrderID CustID SalesReplD ORD1 Gaga Avore ORD2 Judge Avore ORD3 Mill Janovic ORD4 Sandler O'Connor ORD5 Sandler Ortiz ORD6 Wahlberg Walker ORDT Judge Ortiz OrderDate 28-Mar-19 28-Mar-19 15-Jan-19 20-Feb-19 08-Feb-19 05-Mar-19 28-Mar-19 1. What was the total dollar amount of sales? Answer 2. Measured by unit sales, which product was LB's biggest seller and many units were sold. Answer 3. How much commissions were earned by all reps selling Dr. Lasel Answer 4. How much commissions were earned by Malcolm Avore Answer 5. How much commission were earned by all reps in the month of March

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Security Audit And Control Features SAP ERP

Authors: Isaca

4th Edition

1604205806, 978-1604205800

More Books

Students also viewed these Accounting questions

Question

What have you learned from your past jobs?

Answered: 1 week ago