Question

2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due 125 days", and it should change the terms_due_days column to 125.

Answer 1

UPDATE Terms
SET terms_description = 'Net due 125 days',
    terms_due_days = 125
WHERE terms_id = 6;