What is the SQL command to list values in attribute \"EYE_COLOR\" in TABLE \"EYE

Question

What is the SQL command to list values in attribute "EYE_COLOR" in TABLE "EYE_COLORS" whos alias is EC that links to attribute "EYE_COLOR_CODE" a FK in table "MONSTERS" whos alias is MSTR. Show only EYE_COLORS of monsters having the "EVIL_POWER" "Glamouring". Drag the options to the provided blanks to construct the rest of the SQL statement. EYE_COLORS AS EC SELECT AS EYE_COLOR_MONSIER_TOTAL, EVIL_POWER = SKIN COLOR DESC FOR ORDER BY EC.EYE_COLOR COUNT(EYE_COLOR) MONSTERS AS MSTR, MSTR.EYE_COLOR_CODE = EC.EYE_COLOR_CODE WHERE DESC AND JOIN Glamouring FROM EYE_COLOR = EYE_COLOR_CODE

Explanation / Answer

SELECT EC.EYE_COLOR FROM EYE_COLORS AS EC
JOIN MONSTERS AS MSTR
ON (MSTR.EYE_COLOR_CODE=EC.EYE_COLOR_CODE AND EVIL_POWER='Glamouring')
WHERE EYE_COLOR = EYE_COLOR_CODE;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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