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