AA WHERE clause can be used to restrict both rows and groups.
BA WHERE clause can be used to restrict rows only.
CA HAVING clause can be used to restrict both rows and groups.
DA HAVING clause can be used to restrict groups only.
EA WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
FA HAVING clause CANNOT be used in subqueries.