Here's something I call OVERkill:

with cte_ftSales(SalesPersonNm, SalesQty, SalesAmt)

AS(

SELECT 'Rick', 3, 15.00

UNION ALL

SELECT 'Joe', 12, 3.50

UNION ALL

SELECT 'Tommy', 9, 47.53

UNION ALL

SELECT 'Betty', 3, 7.63

UNION ALL

SELECT 'David', 18, 3.50

)

SELECT

SalesPersonNm,

SalesQty,

SalesAmt,

RANK() OVER(ORDER BY SalesQty)...