Write SQL SELECT statements to perform simple, one-table queries.

Description

Write a series of SQL statements to query the OrderEntry database which consists of the tables and rows as shown on pages 121 - 123 of your text.

This assignment will be completed using MS Access. You may use MS Access 2003 or later. The CS Athena remote terminal server has MS Access 2007 installed and available for student use. Instructions for using the Athena server can be found at
http://rbhilton.com/wsucs/cs2550/CS2550TSInstructions.pdf

Complete the assignment by performing the following

1. Download the OrderEntry.mdb database for use in this and future lab work.
   Note that the data and structure for OrderEntry.mdb is contained on pages 121-123.
   The link for downloading the file is http://rbhilton.com/wsucs/cs2550/OrderEntry.mdb.removethis
   (Rename the file to OrderEntry.mdb after downloading)
   
   
2. Run notepad and create a text file named "CS2550A02.txt". At the top type
   CS2550 SQL Assignment 2
   Spring 2010
   <your name>
   
   
3. Use MS Access to create and test SQL queries to perform the following. After you have each query working correctly, copy and paste the full SQL statement to the notepad text file. Number each query accordingly. SAVE YOUR TEXT FILE between each query.
   
   1. List the first name, last name, city and state for all Customers.
   2. List the first name, last name and phone of all Employees.
   3. List the first name, last name and balance of Customers in Denver.
   4. List the product name for all products costing more than $150.
   5. List the name and phone number for all employees in area code 303.
   6. List all order lines with a quantity greater than 3.
   7. List the order name for all orders in Seattle.
   8. List the order number and order date for all orders placed in January 2007.
   9. List the products without a next ship date.
   10. List the names of customers with balances between $200 and $350.

Number each SQL statement and put them into a single text file named CS2550A02.txt  and upload the file using the Assignment Uploader.