Question: Update the product table to make the P QTYOH equal to the currently held amount minus 1 for the product code given above. Update the

Update the product table to make the P QTYOH equal to the currently held amount minus 1 for the product code given above. Update the customer table to make the CUS DATELSTPUR equal to the transaction date given above, the customer balance equal to the current balance plus the current balance with the 8 percent tax added to the unit price for the customer code given above (one SQL statement to perform this set of tasks). Write a T-SQL select statement to display all customer fields for customer number 10010. Copy and paste the results following your SQL statement
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
