On the customers table of the sample database NorthWind compute:

  1. the contents of the table product
  2. the values of the ID (primary key) of products
  3. the values of the contactname and contacttitle fields of customer
  4. the employees with a NULL note
  5. the total number of orders
  6. the number of orders for each customer
  7. for each customer, the number of orders such that ShipVia is 2.

The schema and the code to create the DB.