CREATE TABLE employees (department_id VARCHAR2, commission_pct VARCHAR2)

display those departments where more than ten employees work who got a commission percentage.
SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10
SELECT "department_id" FROM "employees" GROUP BY "department_id" HAVING COUNT("commission_pct") > 10