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

Question

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

Quizplus · Accepted Answer

Option B provides the most comprehensive selection by including all items in Storehouse 3 and any items with more than 20 units on hand, even if they are not in Storehouse 3. Option C only includes items in Storehouse 3, but does not consider the quantity on hand. Option D only includes items with more than 20 units on hand, but does not consider the storehouse location. Option A is a combination of both criteria, but it specifies the Customer table instead of the Item table, which does not provide the desired information.

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