Solved

Based on the Code Above,list the Descriptions of All Parts

Question 53

Multiple Choice

Based on the code above,list the descriptions of all parts that are located in Warehouse 3 and for which there are more than 20 units on hand.


A) SELECT Description FROM Part WHERE Warehouse='3' AND OnHand>20 ;
B) SELECT Description FROM Part WHERE Warehouse='3' OR OnHand>20 ;
C) SELECT Description FROM Part WHERE Warehouse='3' ;
D) SELECT Description FROM Customer WHERE Warehouse='3' AND OnHand>20 ;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions