What is the SQL command to change the value in attribute \"Evil_Power\" to \"Tel

Question

What is the SQL command to change the value in attribute "Evil_Power" to "Telekinetic" and the value in "AGE" to "100" and consider only values in attribute "WEIGHT" that are less than or exactly, '100' for table "MONSTERS"

What is the SQL command to change the value in attribute "EVIL POWER" to "Telekinetic" and the value in "AGE" to "100" and consider only values in attribute WEIGHT" that are less than or exactly '1000 for table "MONSTERS Drag the options to the provided blanks to construct the SQL statement. 'SET' COLLECT AGE MONSTERS Telekinetic Telekinetic 1OO WHERE UPDATE WEIGHT 1000 WEIGHT SET '10 TABLE MONSTERS "1000 EVIL POWER

Explanation / Answer

SQL command :

UPDATE MONSTERS
SET Evil_Power = 'Telekinetic', AGE = 100
WHERE WEIGHT<=100;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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