Database: college_1
Question: What is the count and code of the job with the most employee?
SQL:
SELECT emp_jobcode ,  count(*) FROM employee GROUP BY emp_jobcode ORDER BY count(*) DESC LIMIT 1