Answer the following questions. Make sure you use comments in your SQL file to clarify/show which...

Transcribed Image Text:

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 office 6. Write a query to show the number of customers who have not placed any orders. 7. Write a query to show the number of products that have not been ordered 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 offices that have more than four employees. 10. Write a query to show the orders that their value is more than 50000 (order value quantityOrdered priceEach) 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 office 6. Write a query to show the number of customers who have not placed any orders. 7. Write a query to show the number of products that have not been ordered 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 offices that have more than four employees. 10. Write a query to show the orders that their value is more than 50000 (order value quantityOrdered priceEach)

Answer rating: 100% (QA)

Certainly Below are SQL queries to answer each of the questions youve provided Ive added comments to clarify which query corresponds to which question ... View the full answer