Homework

As with the last project, download the Northwind database (northwind.mdb) and re-familiarize yourself with its contents. Write SQL queries that do the following:

• Return a list of the names of all the products.
• Return the company names of all the customers from Paris, France.
• Return the fullnames of the employees, alphabetized by last, then first name.
• Return the order ID, customer name, and the names of the products for each customer order
• Return the number of products from each supplier.

Here, you'll just submit the SQL commands as text, rather than saving them as queries in the database file.

Personal Database Project

Write 3 interesting SQL queries for your project database. One of them should involve multiple tables and one should involve grouping/aggregation. Make these queries return something that a user of your database may actually want to know, and make them different from the three queries you turned in in project #4.

What to turn in:

Use Knightvision to submit your SQL commands. Submit them in text form in an attached Word file.