Find the count and code of the job has most employees.
CREATE TABLE employee (emp_jobcode VARCHAR)
SELECT emp_jobcode, COUNT(*) FROM employee GROUP BY emp_jobcode ORDER BY COUNT(*) DESC LIMIT 1
### Context: CREATE TABLE employee (emp_jobcode VARCHAR) ### Question: Find the count and code of the job has most employees. ### Answer: SELECT emp_jobcode, COUNT(*) FROM employee GROUP BY emp_jobcode ORDER BY COUNT(*) DESC LIMIT 1