SAP Business One query that compares all salespersons

 SELECT T0.SlpName AS 'Salesperson', SUM(T1.LineTotal) AS 'Total Sales'

FROM OSLP T0 INNER JOIN ORDR T2 ON T0.SlpCode = T2.SlpCode INNER JOIN RDR1 T1 ON T2.DocEntry = T1.DocEntry WHERE T2.DocDate >= '[%0]' AND T2.DocDate <= '[%1]' GROUP BY T0.SlpName ORDER BY SUM(T1.LineTotal) DESC