Home / Questions / Consider the following Employee table. Which of the following statements give the list of

Consider the following Employee table. Which of the following statements give the list of

Consider the following Employee table.

Which of the following statements give the list of departments having average salary greater than 20000 from employee table?

(a)SELECT Dept_No,AVG(Salary) FROM Employee ORDER BY Dept_No HAVING AVG(Salary)>20000
(b)SELECT Dept_No,AVG(Salary) FROM Employee HAVING AVG(Salary)>20000
(c)SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No HAVING AVG(Salary)>20000
(d)SELECT Dept_No,AVG(Salary) FROM Employee WHERE AVG(Salary)>20000
(e)SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No WHERE AVG(Salary)>20000.

Dec 29 2017 Read more Less More

Answer (Solved)

question Get solution

Recent Questions

Chat Now

Welcome to Live Chat

Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.

Please fill in the form