What is the SQL command to select the value in attributes \"EYE_COLOR\" and \"SK

Question

What is the SQL command to select the value in attributes "EYE_COLOR" and "SKIN_COLOR" of "MONSTERS" who's "EVIL_POWER" is "Glamouring" List the results by the different eye colors and the number of monsters for each. Only display the color ifthe number of monsters is greater than 5.

What is the SQL command to count values in attribute "EYE_COLOR" that holds total count in a derived column "EYE COLOR MOSTER TOTAL of table "MONSTERS" who's "EVIL_POWER" is "Glamouring". List the results by the different eve colors and the number of monsters for each. Only display the color if the number of monsters is greater than 5 Drag the options to the provided blanks to construct the rest of the SQL statement. GROUP BY EYE COLOR SKIN COLOR DESC EVIL POWER= COUNT(EYE COLOR) MONSTERS AS EYE COLOR MONSTERTOTAL EYE COLOR ORDER BY OR DESC EYE COLOR MONSTER TOTAL 5 'Glamouring WHERE HAVING FROM COUNTOSKIN COLOR) SELECT

Explanation / Answer

SELECT COUNT(EYE_COLOR) AS EYE_COLOR_MONSTER_TOTAL
FROM MONSTERS
WHERE EVIL_POWER='Glamouring'
GROUP BY EYE_COLOR
HAVING EYE_COLOR_MONSTER_TOTAL>5;

I hope this sequence works.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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