examine the data in employees table given below lastname departmentid salary allen..., MySQL, 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 will execute well?

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));

/71

+ AnswerC

+ Report

Descriptive on MySQL Ebook

Total Preview: 761

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 will execute well?

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