SQL Queries

Create the following SQL Server queries that access the SQL Server Northwind database. Place them in a zip file and place the zip file in the Digital Drop Box. Name the queries Query1-MP4, Query2-MP4, etc.

This is a SQL Server Assignment. Some of the problems require aggregate functions and others do not. You must decide for yourself as you read each one.

1. The order id, customer name, order date, and total cost of all items ordered for all orders that were shipped to Spain.
2. The customer id, company name, number of orders, and total order amount for all customers. Place the list in order by customer city and then by customer id.
3. Same as problem 3, but limit the list to all customers who placed 3 or more orders.
4. The Company Name, Contact Name, City, and Country for all customers from London, Madrid, or Buenos Aires.
5. The product ID, name, and quantity ordered for all products that were shipped to Spain or Portugal prior to January 1, 1997. Place the list in ascending order by product name.
6. The order number, customer name, country to which the order is shipped and the name of the employee who took the order for all orders that contain an item in the category Beverages. You must use the category name in your query.