Principles of Database Management

Do this assignment using SQL Server as shown in class. Create the following queries that access the Northwind database. Place them in .txt file and place the .txt file in the appropriate drop box in the Assignments section. 1. The Company Name, Contact Name, and City for all customers from France or USA. 2. The customer id and name of all customers that purchased an item whose category ID is 2 . 3. The product ID and name for all products that were shipped on or after July 16,1996 . Place the list in ascending order by shipped date. 4. The product ID, name, unit price, and units in stock for all products that were purchased by any customer from Germany, Austria, or Sweden. Place the list in alphabetical order by country and then by product ID. 5. The category ID, category name, product number, product name, units in stock, and units on order for all items that have a zero value in units on order. Place the list in alphabetical order by category name and then by product name. 6. The order number, company name, city to which the order is shipped, and freight amount for all orders that contain an item supplied by a supplier named Exotic Liquids. You must use the supplier name in your query. 7. The company name for all customers that purchased an item in the Beverages or Condiments category. List each name only once and place the names in alphabetical order. 8. The product ID and name for all products that were ordered by a customer named Ernst Handel. Use the name and not the customer ID in the query. Place the list in alphabetical order by product name. 9. The order ID, customer ID, company name, and destination city for all orders shipped to Mexico or USA. Place the list in alphabetical order by company name. 10. The product ID, product name, and quantity ordered for all products ordered on an order taken by an employee named Robert King. Place the list in alphabetical order by product name