Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* What is the average freight charge for all orders shipped to France and United States beginning in December 1996? */
- /* Attempt #1: http://pastebin.com/8RwHP6Et */
- /* All orders shipped to FR and US since 12/1/1996 */
- SELECT SOH.ShipDate, SOH.Freight, ST.CountryRegionCode FROM [Sales].[SalesOrderHeader] SOH
- JOIN [Person].[Address] Addr ON SOH.ShipToAddressID=Addr.AddressID
- JOIN [Person].[StateProvince] StateProvince ON Addr.StateProvinceID = StateProvince.StateProvinceID
- JOIN [Sales].[SalesTerritory] ST ON StateProvince.TerritoryID = ST.TerritoryID
- WHERE ST.CountryRegionCode IN ('US', 'FR') AND SOH.ShipDate > '12/1/1996'
Advertisement
Add Comment
Please, Sign In to add comment
