List roles that have more than one employee. List the role description and number of employees.
CREATE TABLE ROLES (Id VARCHAR); CREATE TABLE Employees (Id VARCHAR)
SELECT Roles.role_description, COUNT(Employees.employee_id) FROM ROLES JOIN Employees ON Employees.role_code = Roles.role_code GROUP BY Employees.role_code HAVING COUNT(Employees.employee_id) > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE ROLES (Id VARCHAR); CREATE TABLE Employees (Id VARCHAR) Question: List roles that have more than one employee. List the role description and number of employees. [/INST] SELECT Roles.role_description, COUNT(Employees.employee_id) FROM ROLES JOIN Employees ON Employees.role_code = Roles.role_code GROUP BY Employees.role_code HAVING COUNT(Employees.employee_id) > 1 </s>