Solved

Based on the Code Shown, Which Query Lists the Descriptions

Question 18

Multiple Choice

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 ;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions