Based on the code shown, which query lists the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand, or both???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
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 shown, which query lists the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand, or both???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
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

The query "SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20" will 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. Choice A only lists items that meet both conditions, while choice C only lists items in Storehouse 3. Choice D only lists items with more than 20 units on hand.

Based on the Code Shown, Which Query Lists the Descriptions