> > >

Hadoop MCQs

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

select OrderDate,Amount from orders where sum(amount) > 20000

select OrderDate,Amount from orders where sum(amount) > 20000 order by OrderDate

select count(OrderDate),sum(amount) from orders group by OrderDate having sum(amount) > 20000

select count(OrderDate),sum(amount) from orders group by OrderDate where sum(amount) > 20000

Answer

Correct Answer:

Explanation:

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

Hadoop Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it