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:
















































OrderNo



PurchaseAmt



OrderDate



Customer_ID



Salesman_Id



1001



150.5



1-01-2021



111



211



1002



250.75



2-01-2021



112



212



1003



500.00



2-01-2021



113



213



1004



100.00



3-01-2021



113



214



1005



57.34



4-01-2021



114



214





  1. Find the minimum PurchaseAmt for Customer_ID 113

  2. Find the maximum PurchaseAmt for Salesman_ID 214

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

  4. Update the Customer_ID as 115 whose PurchaseAmt is 150.5



Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here