write a query to find the highest average sales among all the salespersons using the given table.
Answers
Answered by
0
Select distinct
Orders,Sales ID, MAX(Orders,Order amount)
From
Order , SalesPerson
Where
Orders , SalesID= Salesperson , SalesID
Group by
Orders, SalesID= Salesperson , Salesname
Order by
MAX(Orders , OrderAmount) DESC
Orders,Sales ID, MAX(Orders,Order amount)
From
Order , SalesPerson
Where
Orders , SalesID= Salesperson , SalesID
Group by
Orders, SalesID= Salesperson , Salesname
Order by
MAX(Orders , OrderAmount) DESC
Answered by
1
However organizations presently depend on in reverse looking strategies to measure the effect of this spending.
Since firms measure just past deals execution (utilizing measurements, for example, income produced, unit deals, and transformation rates), they have restricted understanding into how a businessperson will do going ahead and what kinds of preparing and motivators will be best.
Similar questions