Here is my post for this:

USE TSQLFundamentals2008;

SELECT ord.orderid, ord.custid, ord.shipcity

,SUM(ord.freight) OVER(PARTITION BY ord.shipcity) AS TotalFreight

FROM Sales.Orders AS ord

ORDER BY ord.shipcity;

Spencer Moeller sjmoeller1264@gmail.com