Question: Attempt all questions using the TSQLV4 database. : Database is here :https://raw.githubusercontent.com/ktaranov/sqlserver-kit/master/Sample_Databases/TSQLV4.sql 5 High freight charges in 2015 Return the ship countries with the highest
Attempt all questions using the TSQLV4 database. : Database is here :https://raw.githubusercontent.com/ktaranov/sqlserver-kit/master/Sample_Databases/TSQLV4.sql
5 High freight charges in 2015
Return the ship countries with the highest average freight in 2015, in descending order by average freight.
6 Orders from the customer(s) with the greatest number of orders
Write a query that returns all orders placed by the customer(s) who placed the highest number of orders.
7 High freight charges the last year (the last 12 months)
Return shipcountry, AverageFreight during the last 12 months of order data, using as the end the last OrderDate in Orders.
8 Inventory List
Return EmpID, LastName, OrderID, ProductName, and Qty for all orders.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
