Advertisement
Guest User

Untitled

a guest
Sep 18th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.52 KB | None | 0 0
  1. mines:
  2.  
  3. SELECT TOP 3 shipcountry, AVG(freight) AS favg FROM Sales.Orders
  4. WHERE YEAR(shippeddate) = 2007
  5. GROUP BY shipcountry
  6. ORDER BY favg DESC
  7.  
  8. RETURNS:
  9.  
  10. Austria         186,513
  11. Switzerland 117,1775
  12. Germany         103,1018
  13.  
  14.  
  15. a solution from a book:
  16.  
  17. SELECT TOP(3) shipcountry, AVG(freight) AS avgfreight
  18. FROM Sales.Orders
  19. WHERE orderdate >= '20070101' AND orderdate < '20080101'
  20. GROUP BY shipcountry
  21. ORDER BY avgfreight DESC;
  22.  
  23. RETURNS:
  24. Austria         178,3642
  25. Switzerland 117,1775
  26. Sweden          99,5122
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement