display those departments where more than ten employees work who got a commission percentage.
CREATE TABLE employees (department_id VARCHAR, commission_pct VARCHAR)
[SQL] SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10 [/SQL]