Your assignment is to write and execute the SQL queries that will produce the data $($record sets$)$

requested below using the Pine Valley Furniture database in Microsoft Access and Teradata SQL

Assistant. Please print out a copy of the Pine Valley Furniture Database Description document

for reference purposes as you work on this assignment. Use Microsoft Access. After you are

able to run your SQL statement and get the desired result, copy your

$(1)$ SQL statement $($as text$),$ and

$(2)$ the Recordset $($your output$/$results$)$ from each SQL statement

When you have finished, please submit this Word document $($including your SQL statements

and output$)$ in BBLearn. You may want to use the $$Snipping Tool$$ to copy the recordset

$($output$).$

$1.$ List customer ID$,$ customer name, order ID$,$ and order date, for all customers who have

placed orders.

Hint: You need to include $2$ tables in your FROM clause and you will need $1$ JOIN

$2.$ List customer ID$,$ customer name, order ID$,$ order date, product ID and the quantity of

each product ordered, for all customers who have placed orders.

Hint: You need to include $3$ tables in your FROM clause and you will need $2$ JOINS

$3.$ List customer ID$,$ customer name, order ID$,$ order date, product name, quantity ordered,

and price of each product, for all customers who have placed orders.

Hint: You need to include $4$ tables in your FROM clause and you will need $3$ JOINS

$4.$ List the customer name, city, and state of customers who ordered products $3$ or $4.$

Hint: You need to include $3$ tables in your FROM clause and you will need $2$ JOINS

$5.$ List the customer name, order date, and product description for those customers who

have purchased a Computer Desk.

Hint: You need to include $4$ tables in your FROM clause and you will need $3$ JOINs

$6.$ Which products were ordered before $10/22/2008?$ List the product name, the quantity

ordered, and the order date for all orders placed before $10/22/2008.$

Hint: Remember to use # sign as a delimiter for the date $($order$\_$date $<$ #$10/22/2008$#$).$

$7.$ Write a query that will list the customer$\_$name for orders that were placed before

$10/22/2008.$

$8.$ Extra Credit $($worth $1$ pt$)$ Now write a nested query that will list the customer$\_$name for

orders that were placed before $10/22/2008.$

Hint: Your inner query should retrieve customer$\_$ID from the order$\_$t table and your

outer query should retrieve customer$\_$name from the customer$\_$t table. Use the IN

command in the WHERE clause of your outer query. See the class slides for an example.