SELECT SalesOrderID,
RANK() OVER (ORDER BY DueDate)
AS [Ship Priority],
DueDate
FROM Sales.SalesOrderHeader
ORDER BY DueDate
a
b
c
