Question:A wholesale merchant shop needs a report about the sale where total sale of the day is more than $50,000. Which of the following will fulfill this requirement?
A select * from orders where sum(amount) > 50000
B select * from orders where sum(amount) > 50000 order by OrderDate
C select * from orders group by OrderDate where sum(amount) > 50000
D select * from orders group by OrderDate having sum(amount)>50000
+ AnswerD
+ Report