06. Write a query to display the sales person ID and the total number of sales orders processed by each sales person. In addition, display the commision earned by each sales person. Commision is given to each sales person at the rate of $ 10 per order. Exclude the orders where sales person ID is null. The details of the sales person who has got the maximum commision should be displayed first in the result set.

With sales_Cte(salesPersonID, totalsalesOrder)
as
(
select salesPersonID, Count(salesorderID)
from sales.salesOrderHeader
where salesPersonID is not Null
Group by salesPersonID
)
selectr salespersonID,TotalSalesOrder,Commission= TotalSalesOrder*10
from sales_Cte
OrderBy TotalsalesOrder desc