> > >

PostgreSQL MCQs

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?

select * from orders where sum(amount) > 50000

select * from orders where sum(amount) > 50000 order by OrderDate

select * from orders group by OrderDate where sum(amount) > 50000

select * from orders group by OrderDate having sum(amount)>50000

None of above

Answer

Correct Answer: None of above

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it