Using the northwind database, write SQL statements to:

1. Get get product code for all products in the canned meat category
2. For each product ID, determine the total number of orders for that product (i.e., product 1 has 3 orders, product 7 has 14 orders, etc.)
3. Determine the number of customers from Oregon
4. List all the cities where employees live (each city should be listed once, even if multiple employees live there)
5. For each order, list the order id and the number of days between when it was ordered and when it shipped
6. Create a new customer (you may make up the appropriate details)
7. Update the database after Robert Zare was promoted to Sales Manager
8. Get the date and id of all orders placed during April 2006.