SELECT SalesmanID, SUM(Total) AS Sales, COUNT(*) AS Orders ; FROM mytable ; GROUP BY 1>This should be an easy SQL statement but I cannot figure out how to do it.
Inv_Date Date >Total N10.2 >SalesmanID C5>
Salesman Sales Orders
>MCMW 210,382 14
>ALCS 155,417 12
>PCKD 120,232 8
>