Based on the code above,list the descriptions of all parts that are located in Warehouse 3 or for which there are more than 20 units on hand,or both.
A)SELECT Description FROM Customer 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 Part WHERE OnHand20 ;

Question

Based on the code above,list the descriptions of all parts that are located in Warehouse 3 or for which there are more than 20 units on hand,or both.
A)SELECT Description FROM Customer 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 Part WHERE OnHand>20 ;

Quizplus · Accepted Answer

The correct SQL query is B, which selects descriptions from the Part table where the parts are either located in Warehouse 3 or have more than 20 units on hand, or both.

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