Based on the code above,list the descriptions of all items that are not in Storehouse 3.Based on the code above,list the descriptions of all items that are not in Storehouse 3.
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 above,list the descriptions of all items that are not in Storehouse 3.Based on the code above,list the descriptions of all items that are not in Storehouse 3.
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

Option D selects all the descriptions of items that are not in Storehouse 3, which is the desired output. Option A selects descriptions from the Customer table and checks if the storehouse is not 3, which is not what was asked in the question. Option B selects items that are only in Storehouse 4, which is not what was asked in the question. Option C selects items in storehouses greater than 3, which includes Storehouse 4 and any other storehouses with higher numbers.

​Based on the Code Above,list the Descriptions of All Items

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