Case Study $2$ of $3$: SQL with Pine Valley Furniture Company Database

Business Intelligence and Analytics

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$).$

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

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