The Board of Directors of Northwind have appointed Doug Hanus at their new CEO and Jeff Hogan as their operational manager. They are planning to devote their first two weeks in office to gain a better understanding of Northwinds supply chain and marketing processes. As senior database analyst for Northwind, it is your responsibility to code appropriately structured SQL statements for retrieving the following information requested by Doug and Jeff. They need it on or before 03/03/2019.

Please type your SQL statements without the database file.

1. A listing of Northwinds product categories and the description of each product category. [1 pt.]
2. A clearer picture of the geographical footprint of their customers and suppliers - they want separate listings of the countries in which their customers and suppliers are located. [2 pts]
3. With the intent of expanding operations in Germany, a count of the cities where Northwind has customers in Germany and a listing of those cities. [2 pts]
4. A count and a listing of the cities and corresponding countries in North America (USA, Canada, Mexico) where they have a customer base. [2 pts]
5. The average, sum, maximum, and minimum per unit cost across all products in their product line. They would also like to know the names of Northwinds products having per unit cost between 30 and 50 (both inclusive). [4 pts]
6. The category name and a count of the number of products within each category. The listing should be sorted by category name. [4 pts]
7. A listing of the product names and supplier names for all products that make up OrderIDs 10254 and 10260. [5 pts]
8. For orders having OrderID between 10250 and 10270, a listing of the corresponding customer, employee who accepted the order, and the shipper. The listed must be sorted alphabetically by customer name. [6 pts]
9. A listing of the customer name, last name of employee who accepted the order, and the shipper for all orders from customers based in North America and shipped through either United Package or Federal Shipping. The listed must be sorted alphabetically by customer name. [6 pts]