Suppose we would like to discount books that cost more than $20 to $15. Which of
ID: 3642554 • Letter: S
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 > 20UPDATE 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
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.