Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SOH.ShipDate, ST.CountryRegionCode, AVG(SOH.Freight) avg_freight FROM [Sales].[SalesTerritory] ST
- JOIN [Sales].[SalesOrderHeader] SOH ON ST.TerritoryID = SOH.TerritoryID
- WHERE ST.CountryRegionCode IN ('US', 'FR') AND SOH.ShipDate > '12/1/1996'
- ORDER BY SOH.ShipDate
Advertisement
Add Comment
Please, Sign In to add comment