Restricting Groups

Sheila needs to display the department ID and maximum salary for departments that have a maximum salary greater than 10,000. She will use use the HAVING clause to exlude any group results that do not meet the criterion of having a maximum salary of 10,000.

Show Me and Try It: Use SQL Workshop to build this report