What is the count and code of the job with the most employee?
SELECT emp_jobcode ,  count(*) FROM employee GROUP BY emp_jobcode ORDER BY count(*) DESC LIMIT 1
job with the most employee refers to MAX(COUNT(employee_id)); count of the job refers to COUNT(*); code of the job refers to emp_jobcode;