I noticed an interesting feature when I do "Grouping by Two Columns" on table with PrimaryKey (Clustered Index Unique):

select ProductID,Shelf,sum(Quantity)

from Production.ProductInventory

group by ProductID,Shelf

In this case, the result is automatically...