examine the data in employees table given below lastname departmentid salary allen..., SQL, Databases

Question: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?

A SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); 
B SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); 
C SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); 
D SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); 
E SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

/98

+ AnswerC D

+ Report

Descriptive on SQL Ebook

Total Preview: 5196

Question: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?

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

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

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

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

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

C D