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 09/23/2017.

Please type your SQL statements without the database file.

1. A listing of Northwinds customers.

2. A listing of Northwinds customers based in UK and France.

3. A listing of Northwinds product categories and the description of each product category.

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

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

6. A count and a listing of the cities and corresponding countries in North America (USA, Canada, Mexico) where they have a customer base.

7. 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). [3 pts] 8. A listing of the product names and its corresponding category for products from suppliers based in Germany and France.

9. For orders having OrderID between 10250 and 10265, a listing of the corresponding customer, employee who accepted the order, and the shipper. The listed must be sorted alphabetically by customer name.

10. A listing of the product names and supplier names for all products that make up OrderIDs 10254 and 10260.