Hello,

I was recently let go from my job as a DBA and I'm working on setting up a user group presentation.  I've already started the process by reaching out to...

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