Had dout in data structures: Create the given table and implement the queries: OrderNo PurchaseAmt OrderDate Customer_ID Salesman_Id 1001 150.5 XXXXXXXXXX 111 211 1002 250.75 XXXXXXXXXX 112 212 1003...

Had dout in data structures:

Create the given table and implement the queries:

1. Find the total PurchaseAmt for all the orders


2. Find the average PurchaseAmt for all the orders


3. Find the total count of orders done.


4. Find the minimum PurchaseAmt for Customer_ID 113


5. Find the maximum PurchaseAmt for Salesman_ID 214


6. Display all the details in descending order of PurchaseAmt.


7. Update the Customer_ID as 115 whose PurchaseAmt is 150.5