luisnaranjo733

Untitled

Oct 14th, 2015
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.27 KB | None | 0 0
  1. SELECT SOH.ShipDate, ST.CountryRegionCode, AVG(SOH.Freight) avg_freight FROM [Sales].[SalesTerritory] ST
  2. JOIN [Sales].[SalesOrderHeader] SOH ON ST.TerritoryID = SOH.TerritoryID
  3. WHERE ST.CountryRegionCode IN ('US', 'FR') AND SOH.ShipDate > '12/1/1996'
  4. ORDER BY SOH.ShipDate
Advertisement
Add Comment
Please, Sign In to add comment