Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.
A) SELECT Description FROM Item WHERE Storehouse='3' AND OnHand20 ;
B) SELECT Description FROM Item WHERE Storehouse='3' OR OnHand20 ;
C) SELECT Description FROM Item WHERE Storehouse='3' ;
D) SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand20 ;

Question

Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.​
A) ​SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ;
B) ​SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ;
C) ​SELECT Description FROM Item WHERE Storehouse='3' ;
D) ​SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;

Quizplus · Accepted Answer

Choice A specifies both the condition that the items should be located in Storehouse3 and that there should be more than 20 units on hand. The other choices either include items from other storehouses or do not consider the condition of having more than 20 units on hand. Choice D also includes the Customer table, which is not relevant for this question.

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