Based on the code above,list the descriptions of all parts that are not in Warehouse 3.
A)SELECT Description FROM Customer WHERE NOT Warehouse='3' ;
B)SELECT Description FROM Part WHERE Warehouse='4' ;
C)SELECT Description FROM Part WHERE Warehouse'3' ;
D)SELECT Description FROM Part WHERE NOT Warehouse='3' ;

Question

Based on the code above,list the descriptions of all parts that are not in Warehouse 3.
A)SELECT Description FROM Customer WHERE NOT Warehouse='3' ;
B)SELECT Description FROM Part WHERE Warehouse='4' ;
C)SELECT Description FROM Part WHERE Warehouse>'3' ;
D)SELECT Description FROM Part WHERE NOT Warehouse='3' ;

Quizplus · Accepted Answer

Option D selects all parts that are not in Warehouse 3, which is what the question is asking for. Option A selects all customer descriptions that are not associated with Warehouse 3. Option B selects all part descriptions that are specifically in Warehouse 4. Option C selects all part descriptions that are in a Warehouse with a number greater than 3, which includes Warehouse 4 but also includes any other higher numbered warehouses that may exist.

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