Question: Need help writing the query for this questione please. For Data & information Management class. Answet the following questions. Make sure you use comments in
Need help writing the query for this questione please. For Data & information Management class.
Answet the following questions. Make sure you use comments in your 5QL. file to clarifylshow which 5QL statement is the answer to which question. The questions ate: 1. Write a query to show the total money paid by each customer. 2. Write a query to show the total monty 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 ottice. 6. Write a query to show the number of customers who have not placed any oeders. 7. Write a query to show the number of products that have not been ordered by any customer. 8. Wise a query to show the nuimber of customers trom the USA that paid more than 50000 . 9. Write a guery to show the offices that have more than fout employees. 10. Write a query to show the orders that their value is more than 50000 . (order value a ouantityOrdered'pricef achy
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
