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

 Please tum in only one SQL file (or a bxt file)

Please tum in only one SQL file (or a bxt 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 the total money paid by each customer. 2. Write a query to show the total money paid by each customer per year. 3. Write a query to show the total number of orders from each customer. 4. Write a query to show the total value of each order 5. Write a query to show the number of employees in each otfice. 6. Write a query to show the number of customers who have not nlaced any orders. 7. Write a query to show the number of products that have not been ordeted by any customer 8. Write a query to show the number of customers from the USA that paid more than 50000 9. Write a query to show the otices that have more than four employees. 10. Write a query 10 show the orders that their value is more than 50000 (order value = quantitvOrdered'oriceEach)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!