What is the SQL command to change only the value in attribute \"EVIL_POWER\" to

Question

What is the SQL command to change only the value in attribute "EVIL_POWER" to "MIND_CONTROL" and consider only values in attribute "AGE" that does greater than '10' for table "MONSTERS"

What is the SQL command to change only the value in attribute "EVIL POWER" to "Mind Control" and consider only values in attribute "AGE" that are greater than '10' for table "MONSTERS" Drag the options to the provided blanks to construct the SQL statement. WHERE EVIL POWER COLLECT SET MONSTERS' Mind Control' AGE> Mind Control UPDATE SET 10 MONSTERS AGE ? TABLE 2015 Cengage Learning All Rights Recerved May not he scanned conied or dunlicated or nosted toa nuhlicly accessihle wehsite in whole or in nart

Explanation / Answer

update MONSTERS set EVIL_POWER = "MIND_CONTROL" where age > 10;

This Query updates values of "Evil_POWER"= "MIND_CONTROL" whenever the AGE is greater than 10;

Please rate if you find the answer is helpful..:)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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