3.6 Case 2: A More Complex Query

Demonstration using more complex queries.

Case 2 demonstrates the following:

• The functions SUM(expression) and NVL(expr1, expr2) in the SELECT list
• The GROUP BY and HAVING clauses

This query retrieves the departments from GTW_EMP whose total monthly expenses are higher than $10,000.