display those departments where more than ten employees work who got a commission percentage.
CREATE TABLE employees (department_id VARCHAR, commission_pct VARCHAR)
SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10
### Context: CREATE TABLE employees (department_id VARCHAR, commission_pct VARCHAR) ### Question: display those departments where more than ten employees work who got a commission percentage. ### Answer: SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10