Question:A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used? 

A select * from orders where sum(amount) > 20000 
B select orderdate, sum(amount) from orders where sum(amount) > 20000 order by OrderDate 
C select orderdate, sum(amount) from orders group by orderdate having sum(amount) > 20000 
D select orderdate, sum(amount) from orders group by OrderDate where sum(amount) > 20000 

+ 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