Find the count and code of the job has most employees.
SELECT emp_jobcode ,  count(*) FROM employee GROUP BY emp_jobcode ORDER BY count(*) DESC LIMIT 1
count of employees refers to COUNT(*); job with the most employees refers to MAX(COUNT(*)); job code refers to emp_jobcode;