PLEASE READ: the command JOIN cannot be used. The program will not allow me to d

Question

PLEASE READ: the command JOIN cannot be used. The program will not allow me to drag and drop JOIN to the command. I am assuming that means it does not want me to use JOIN.

PLEASE READ: the command JOIN cannot be used. The program will not allow me to drag and drop JOIN to the command. I am assuming that means it does not want me to use JOIN.

What is the SQL command to list values in attribute "EYE_COLOR" in TABLE "EYE COLORS" who's alias is EC that links to attribute "EYE_COLOR CODE" a FK in table "MONSTERS" who's 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_MONSTER_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

1- select
2- EC.EYE_COLOR
3- from
4- MONSTERS AS MSTR,
5- EYE_COLORS AS EC
6- where
7- MSTR.EYE_COLOR_CODE = EC.EYE_COLOR_CODE
8- AND
9- EVIL_POWER =
10- 'Glamouring'

Please use the exact clause as given in the same order.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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