Based on the code shown, which query lists the descriptions of all items that are not in Storehouse 3???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
A) SELECT Description FROM Customer WHERE NOT Storehouse='3' ;
B) SELECT Description FROM Item WHERE Storehouse='4' ;
C) SELECT Description FROM Item WHERE Storehouse'3' ;
D) SELECT Description FROM Item WHERE NOT Storehouse='3' ;

Question

Based on the code shown, which query lists the descriptions of all items that are not in Storehouse 3???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
A) SELECT Description FROM Customer WHERE NOT Storehouse='3' ;
B) SELECT Description FROM Item WHERE Storehouse='4' ;
C) SELECT Description FROM Item WHERE Storehouse>'3' ;
D) SELECT Description FROM Item WHERE NOT Storehouse='3' ;

Quizplus · Accepted Answer

The query in choice D uses the NOT operator to select all descriptions of items that are not in Storehouse 3.

Based on the Code Shown, Which Query Lists the Descriptions