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

The query needs to specify both the Storehouse and the OnHand condition, which is only satisfied in option A. Option B uses OR instead of AND, which will include any item that is either located in Storehouse3 or has more than 20 units on hand, regardless of whether both conditions are met. Option C only specifies the location but not the OnHand condition, while option D selects from the wrong table (Customer instead of Item).

Based on the Code Shown, Which Query Lists the Descriptions