# Database: Select - Northwind

Name: _________________________________

OPEN BOOK.

Use the Northwind Relational Schema for the tables and fields. Write a SELECT command to answer each of the following questions.

1. (2 points) How many employees are there?
2. (2 points) Show all customers (`Customers.CompanyName`) who are in Germany (`'Germany'`). Order by company name.
3. (3 points) Display the `ProductID` and `ProductName` for all seafood (`Categories.CategoryName='seafood'`) products.
4. (3 points) You want to know who places orders to be shipped to someone else. Display the customer (`Customer.CompanyName`) and the corresponding shipping name (`Orders.ShipName`) where the two names are different on an order. Do not print any combination of names more than once.
5. (3 points) Which shippers (`Shippers.CompanyName`) have ever shipped seafood (`Categories.CategoryName='seafood'`)? Don't print their name more than once even if they have made many shipments.