What keyword is used to filter values obtained by applying aggregate functions in the query results using GROUP BY clause?

Assuming there are multiple rows in the 'Commission_Agents' table with entries for commission agents from different departments, what is the error in the following query:

SELECT name, department_id, commission_percentage from Commision_Agents 

WHERE commission_percentage = (SELECT min(commission_percentage)  FROM Commision_Agents GROUP BY department_id);

What is the difference between CHAR and VARCHAR data types?

Which of the following operators can not be used in the 'WHERE' clause?

Which of the following statements is/are true?

Which of the following is not a valid SQL operator?

Which type of join will yield a Cartesian product?

Must CASE statements always be indented?

What is an alternate way of writing the following statement: WHERE "column_name" IN ('value1')

What is the difference between WHERE and HAVING clauses?

What is a common schema name?