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 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
Some features of managed care that could lower cost and improve quality of care
Nov 30 2017Brian, a psychology student, has had an overall negative impression of his psychology professor. As a consequence, during the end of term appraisal, he rates his professo...
Dec 10 2019Write an essay about How can a portfolio manager use beta to manage a portfolio Give examples of different types of strategies The essay should be one page long Write an ...
Feb 13 2020For the full-step drive circuit in Figure 10.29, complete the following timing diagram by adding signals B0 , B1 , φ1 , φ2 , φ3 , and φ4 . Using Table 10.1, verify that t...
Jul 26 20201. A 100-kΩ resistor has a power rating of 0:25 W. Find the maximum current that can flow through the resistor.2. A certain type of film resistor is available with resist...
Jul 28 2020Air enters a compressor operating at steady state witha pressure of 14.7 lb/in.2 and a temperature of 70degrees F. The volumetric flow rate atthe inlet is 16.6ft3/s, and ...
Jun 05 2020The indented parenthetic representation of a tree T is a variation of the parenthetic representation of T (see Code Fragment 8.26) that uses indentation and line breaks a...
Jun 13 2020Did the New Deal end the Great Depression?
Apr 15 2020Ever since the recent financial crisis introduced the general public to the pitfalls of excessive leverage within the financial system, there’s been a common misconceptio...
May 16 2018Discuss how agency problems can develop between shareholders and bondholders when the firm is experiencing financial distress. 129. Does firm value increase when more deb...
Jan 09 2020Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.