Find the count and code of the job has most employees.
CREATE TABLE employee (emp_jobcode VARCHAR)
SELECT TOP 1 emp_jobcode, COUNT(*) FROM employee GROUP BY emp_jobcode ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employee (emp_jobcode VARCHAR) Question: Find the count and code of the job has most employees. [/INST] SELECT TOP 1 emp_jobcode, COUNT(*) FROM employee GROUP BY emp_jobcode ORDER BY COUNT(*) DESC </s>