Question:Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more numbers far from the minimum stock limit. The structure of the Products table is:
        ProductID
        ProductName
        CurrentStock
        MinimumStock

Two possible queries are:

Statement 1: select * from products where currentStock>MinimumStock+50
Statement 2: select * from products where currentStock-50>MinimumStock

Select an option which is more suitable for these queries: 

A Only statement 1 is correct 
B Only statement 2 is correct 
C Both statements 1 and 2 are correct 
D Both statements 1 and 2 are incorrect 

+ Answer
C 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description