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 ReportsTo
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.
8. the customers that are in Mexico and do not have a fax.

The schema. The Northwind database is available also for several DBMS other than Sqlite.

Notice that there are some small differences between the figure and the actual names of some columns.