Suppose we would like to discount books that cost more than $20 to $15. Which of

Question

Suppose we would like to discount books that cost more than $20 to $15. Which of the following queries, if any, correctly modifies the table? UPDATE books SET Price = 15 WHERE Price > 20 UPDATE books WHERE Price > 20 SET Price = 15 No other answer choice will correctly modify the table. ALTER books ADD Price = 15 WHERE Price > 20
UPDATE books SET Price = 15 WHERE Price > 20
UPDATE books WHERE Price > 20 SET Price = 15
No other answer choice will correctly modify the table.
ALTER books ADD Price = 15 WHERE Price > 20

Explanation / Answer

The first one is correct one

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---