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