display the department id and the total salary for those departments which contains at least two employees.
CREATE TABLE employees (department_id VARCHAR, salary INTEGER)
SELECT department_id, SUM(salary) FROM employees GROUP BY department_id HAVING COUNT(*) >= 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employees (department_id VARCHAR, salary INTEGER) Question: display the department id and the total salary for those departments which contains at least two employees. [/INST] SELECT department_id, SUM(salary) FROM employees GROUP BY department_id HAVING COUNT(*) >= 2 </s>