Question: Please turn in only one SQL file (or a .txt file) and submit it to the Assignment Submission Folder assigned for the homework. Answer the

Please turn in only one SQL file (or a .txt file)Please turn in only one SQL file (or a .txt file)

Please turn in only one SQL file (or a .txt file) and submit it to the Assignment Submission Folder assigned for the homework. Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1. Write a query to show payments that each customer has made so far. Show Customer name check number, and payment date 2. Write a query to show orders made by each customer has made so far. Show Customer name, Order date, Required date, and Shipped date. 3. Write a query to show the office location of each employee. Show employee's first and last name, addressline1, state, country. 4. Write a query to show the name of the products for each order. Show ordernumber, orderdate, and productname. 5. Write a query to show the orderNumber, product name, and quantity ordered. 6. Write a query to show the product code, product name, and image of the product line (join products and productlines). 7. Write a query to show the customer number, payment amount, and order number (join three tables; orders, customers, and payments). 8. Write a query to show the order number, customer number, and customers' city

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To ensure that all parts of the question are answered correctly heres the complete SQL script with c... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!