What is the business problem in WITH salesPersonTotalSales AS

$($WITH orders AS

$($SELECT salesOrderDetail.salesorderid, SUM$($salesOrderDetail$.$orderqty$*($SalesOrderDetail$.$unitPrice$*(1-$salesOrderDetail.unitPriceDiscount$)))$ AS ordertotal

FROM SalesOrderDetail

GROUP BY $1),$

salesPersonAndOrders AS

$($SELECT salesOrderHeader.salesorderid, salesOrderHeader.salespersonid

FROM SalesOrderHeader

WHERE SalesOrderHeader.orderDate $>=\text{'}2014-01-01\text{'}$

AND salesOrderHeader.salespersonid is not NULL

AND salesOrderHeader.salespersonid $<>""$

$)$

SELECT salesPersonAndOrders.salespersonid, SUM$($orders$.$ordertotal$)$ AS ordertotalsum

FROM salesPersonAndOrders

JOIN orders ON salesPersonAndOrders.salesOrderID $=$orders.salesorderid

GROUP BY $1$

ORDER By $1$ desc$)$

SELECT salesPersonTotalSales.salespersonid, salesPersonTotalSales.ordertotalsum, SalesPerson.commissionpct

FROM salesPersonTotalSales

JOIN SalesPerson ON salesPersonTotalSales.salesPersonID $=$ SalesPerson.businessEntityID;WITH salesPersonTotalSales AS

$($WITH orders AS

$($SELECT salesOrderDetail.salesorderid, SUM$($salesOrderDetail$.$orderqty$*($SalesOrderDetail$.$unitPrice$*(1-$salesOrderDetail.unitPriceDiscount$)))$ AS ordertotal

FROM SalesOrderDetail

GROUP BY $1),$

salesPersonAndOrders AS

$($SELECT salesOrderHeader.salesorderid, salesOrderHeader.salespersonid

FROM SalesOrderHeader

WHERE SalesOrderHeader.orderDate $>=\text{'}2014-01-01\text{'}$

AND salesOrderHeader.salespersonid is not NULL

AND salesOrderHeader.salespersonid $<>""$

$)$

SELECT salesPersonAndOrders.salespersonid, SUM$($orders$.$ordertotal$)$ AS ordertotalsum

FROM salesPersonAndOrders

JOIN orders ON salesPersonAndOrders.salesOrderID $=$orders.salesorderid

GROUP BY $1$

ORDER By $1$ desc$)$

SELECT salesPersonTotalSales.salespersonid, salesPersonTotalSales.ordertotalsum, SalesPerson.commissionpct

FROM salesPersonTotalSales

JOIN SalesPerson ON salesPersonTotalSales.salesPersonID $=$ SalesPerson.businessEntityID;