Find the count and code of the job has most employees.
create table employee (emp_jobcode varchar, PRIMARY KEY (emp_jobcode))
select emp_jobcode, count(*) from employee group by emp_jobcode order by count(*) desc limit 1