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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employees (department_id VARCHAR, commission_pct VARCHAR) Question: display those departments where more than ten employees work who got a commission percentage. [/INST] SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10 </s>