Question: What is the SQL command to select the values in attributes EYE_COLOR and SKIN_COLOR of MONSTERS whos's EVIL_POWER is Telekinetic and who's AGE is greater

 What is the SQL command to select the values in attributes

What is the SQL command to select the values in attributes "EYE_COLOR" and "SKIN_COLOR" of "MONSTERS" whos's "EVIL_POWER" is "Telekinetic" and who's "AGE" is greater than "100". List the result in alpabetical order first by "SKIN COLOR", then by "EYE_COLOR".

What is the SQL command to select the values in attributes "EYE COLOR" and "SKIN COLOR" of "MONSTERS" who's "EVIL POWER" is "Telekinetic" and who's "AGE" is greater than "100" List the results in alphabetical order first by "SKIN COLOR", then by "EYE COLOR". Drag the options to the provided blanks to construct the rest of the SQL statement. SELECT EYE COLOR, SKIN COLOR FROM MONSTERS WHERE DESC AND EVIL POWER "MONSTERS". EVIL POWERS "Telekinetic' EYE COLOR ORDER BY ASC CONSTRUCT AGE 10O 100 SKIN COLOR

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!