> > >

Hadoop MCQs

Examine the data in the EMPLOYEES table given below:

LAST_NAME  DEPARTMENT_ID          SALARY
ALLEN                10                3000
MILLER                20                1500
King                20                2200
Davis                30                5000

Which of the following Subqueries work?

SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

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