Can you tell me the amount and code of the job with the most employees?
SELECT emp_jobcode ,  count ( * )  FROM employee GROUP BY emp_jobcode ORDER BY count ( * )  DESC LIMIT 1
amount of employees refers to COUNT(*); job with the most employees refers to MAX(COUNT(*)); job code refers to emp_jobcode;