- Class Cis225 Database Concepts 1 (368.42 KiB) Viewed 33 times
Class: cis225 database concepts
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Class: cis225 database concepts
Class: cis225 database concepts
Use the Orders table below for exercises 10 - 12 ord_no 70001 70009 70002 70004 70007 70005 70008 70010 70003 70012 70011 70013 purch_amt ord_date 150.5 270.65 65.26 110.5 948.5 2400.6 5760 1983.43 2480.4 250.45 75.29 3045.6 customer_id salesanent id 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 2012-09-10 3005 2012-07-27 3007 2012-09-10 3002 2012-10-10 3004 2012-10-10 3009 2012-06-27 3008 2012-08-17 3003 2012-04-25 3002 5002 5005 5001 5003 5002 5001 5001 5006 5003 5002 5007 5001 Source: https://www.w3resource.com/ 10. Write a T-SQL query to display the order number, order date and purchase amount for each order delivered by sales agent 5001 from the order table above. 11. Write a T-SQL query to display the salesagent_id, customer_id, and the purch_amt from the Order table above. Show only those sales agents with a total purch_amt for all customers greater than $2500.00. Assign aliases to all fields. List with the sales agent with the largest amount first. 12. Write a T-SQL query to display customers total purch_amt (for all orders) showing only the total for each customer in descending order.
Use the Orders table below for exercises 10 - 12 ord_no 70001 70009 70002 70004 70007 70005 70008 70010 70003 70012 70011 70013 purch_amt ord_date 150.5 270.65 65.26 110.5 948.5 2400.6 5760 1983.43 2480.4 250.45 75.29 3045.6 customer_id salesanent id 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 2012-09-10 3005 2012-07-27 3007 2012-09-10 3002 2012-10-10 3004 2012-10-10 3009 2012-06-27 3008 2012-08-17 3003 2012-04-25 3002 5002 5005 5001 5003 5002 5001 5001 5006 5003 5002 5007 5001 Source: https://www.w3resource.com/ 10. Write a T-SQL query to display the order number, order date and purchase amount for each order delivered by sales agent 5001 from the order table above. 11. Write a T-SQL query to display the salesagent_id, customer_id, and the purch_amt from the Order table above. Show only those sales agents with a total purch_amt for all customers greater than $2500.00. Assign aliases to all fields. List with the sales agent with the largest amount first. 12. Write a T-SQL query to display customers total purch_amt (for all orders) showing only the total for each customer in descending order.