An SQL statement to display the project name which is controlled by the department whose employees draw salary higher than the average salary of all employees working in the organization can be

Question

Answer

select pname from project, employee where dno = dnumber and salary > (select avg(salary) from employee)

Answer

None of these

Answer

select pname from project, department, employee where dnum = dnumber and dno = dnumber and salary > (select avg(salary) from employee)

Answer

select pname from project, department dnum = dnumber and salary > (select avg(salary) from employee)

Crowdly

An SQL statement to display the project name which is controlled by the departme...

Want instant access to all verified answers on moovit.vit.ac.in?