Principles of Database Management

Create the following SQL Server queries that access the Northwind database. Place them in txt file and place the .txt file in the "drop box" for Assignment 4. Note: These problems all require aggregate processing with GROUP BY 1. For each employee, list the employee ID, employee first name, employee last name, and count of orders taken in 1996. Place the list in descending order by the count of orders. 2. For all orders shipped in July or August, 1996, list the order ID, company name, order date, and total cost of all items ordered. Place the list in descending order by the total cost. 3. For all customers from the USA, list the customer ID, company name, state, count of orders, and total order amount. Do not consider the discount. Place the list in order by state and then customer ID, but limit the list to all customers who placed 3 or more orders. 4. For all items in the Grains/Cereals category, list the product ID, product name, supplier name, and last date that the product was ordered. Order the list by supplier name and product name (Hint: Use MAX and be sure to include all necessary tables) 5. The product ID, product name, and count of distinct customers who ordered that product in 1996. Place the list in descending order by the count of customers. Northwind Database Structure