What is the SQL command to count values in attribute \"EYE_COLOR\" that holds to

Question

What is the SQL command to count values in attribute "EYE_COLOR" that holds total count in a derived column "EYE_COLOR_MONSTER_TOTAL" of table "MONSTERS" who's "EVIL_POWER" is "GLAMOURING". List the results by the difference eye colors andthe number of monsters for each. Only display the color if the 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 eye 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 AS EYE COLOR MONSTER TOTAL EYE COLOR COUNT(EYE COLOR) MONSTERS ORDER BY OR WHERE HAVING DESC EYE COLOR MONSTER TOTAL 5 FROM COUNTOSKIN COLOR) SELECT "Glamouring'

Explanation / Answer

The SQL Statements can be formulated as

SELECT COUNT(EYE_COLOR) AS EYE_COLOR_MONSTER TOTAL, EYE_COLOR
FROM MONSTERS WHERE EVIL_POWER='Glamouring'
GROUP BY EYE_COLOR
HAVING EYE_COLOR_MONSTER_TOTAL>5
ORDER BY EYE_COLOR DESC OR SKIN_COLOR DESC

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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