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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!