What is the SQL command to select the values in attributes \"EYE_COLOR\" and \"S

Question

What is the SQL command to select the values in attributes "EYE_COLOR" and "SKIN_COLOR" of "MONSTERS" whos's "EVIL_POWER" is "Telekinetic" and who's "AGE" is greater than "100". List the result in alpabetical order first by "SKIN COLOR", then by "EYE_COLOR".

What is the SQL command to select the values in attributes "EYE COLOR" and "SKIN COLOR" of "MONSTERS" who's "EVIL POWER" is "Telekinetic" and who's "AGE" is greater than "100" List the results in alphabetical order first by "SKIN COLOR", then by "EYE COLOR". Drag the options to the provided blanks to construct the rest of the SQL statement. SELECT EYE COLOR, SKIN COLOR FROM MONSTERS WHERE DESC AND EVIL POWER "MONSTERS". EVIL POWERS "Telekinetic' EYE COLOR ORDER BY ASC CONSTRUCT AGE 10O 100 SKIN COLOR

Explanation / Answer

Query

select EYE_COLOR, SKIN_COLOR from MONSTERS where EVIL_POWER = 'Telekinetic' and AGE > 100 order by SKIN_COLOR, EYE_COLOR asc;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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