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 OnHand20 ;
B)SELECT Description FROM Part WHERE Warehouse='3' OR OnHand20 ;
C)SELECT Description FROM Part WHERE Warehouse='3' ;
D)SELECT Description FROM Customer WHERE Warehouse='3' AND OnHand20 ;

Question

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 ;

Quizplus · Accepted Answer

This query specifically looks for parts that are located in Warehouse 3 AND have more than 20 units on hand, which is the exact criteria mentioned in the question.

Option B includes parts that may have more than 20 units on hand but are not necessarily located in Warehouse 3.

Option C lists all parts located in Warehouse 3, regardless of the number of units on hand.

Option D queries the wrong table and is not relevant to the question. Therefore, the best choice is A.

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