For each job code, how many employees are there?
select emp_jobcode, count(*) from employee group by emp_jobcode
Which one has the most?
select emp_jobcode, count(*) from employee group by emp_jobcode order by count(*) desc limit 1