COMPUTER SCIENCE 4400 ASSIGNMENT 3

Download the Access database named Northwind by using the link in D2L. Please download a new copy of the file. Write each of the following queries in SQL. Use the SQL view in Access to create and test each one. Name them as indicated. Do not base your queries on the contents of the tables as shown in the database. Place the exact values being searched for in your queries. Other rows might be added to any table. None of these queries require keyboard input.

You must use the names given for the queries. Place the database file that includes your queries in the D2L Drop Box for Assignment 3 on the date shown on the Course Schedule.

Query Name	Instructions
Query1	The product ID and name for all products that cost more than $30.00
Query2	The product name, supplier name, and category name for all products that have been supplied by a supplier from the USA. Place the list in ascending order by product name.
Query3	The product ID, product name, and quantity ordered for all products ordered on an order taken by an employee with last name Fuller.
Query4	The order ID, customer ID, and destination city for all orders shipped to Switzerland. The query should work if the country is changed to some other value.
Query5	The product ID and name for all products that were ordered by a customer named Ernst Handel. The query should still work if the name is changed to any other name. Use the name and not the customer number in the query.
Query6	The company name for all customers that purchased an item in the Confections category. List each name only once and place the names in alphabetical order.