using the TSQLV4 database.

1 High freight charges in 2015

Return the ship countries with the highest average freight in 2015, in descending order by average freight.

2 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.

3 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.

4 Inventory List

Return EmpID, LastName, OrderID, ProductName, and Qty for all orders.

5 Customers with no orders

Show customers who have never placed an order.

6 Customers with no orders for Empid = 4

Although the employee with EmpID = 4 has placed the most orders, there are some customers who have not placed an order with her. List those customers.