Which SQL clause is used to filter group results after a GROUP BY operation has been performed?
Subject: Database Systems
Topic: Database Normalization
Options:
- Option A: WHERE
- Option B: HAVING
- Option C: ORDER BY
- Option D: SELECT
Correct Answer:
Option B: HAVING
Explanation:
The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions; it filters groups rather than individual rows.