Update the product table to make the P QTYOH equal to the currently held amount

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 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.

Explanation / Answer

1.
Update Product
set P_QTOH=amount-1
where P_CODE=given_code;

2.
UPDATE    CUSTOMER
SET CUS_DATELSTPUR=CUS_BALANCE*1.08
WHERE CUS_CODE=given_code;

3.
SELECT * FROM CUSTOMER WHERE CUS_CODE=10010;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.