Select A.jobcode,A.part_timed_count,b.full_timed_count
(Select jobcode,count(full_part_time) part_timed_count from job where
full_part_time in 'p' group by jobcode) A
(Select jobcode,count(full_part_time) full_timed_count from job where
full_part_time in 'f' group by job_code) B where A.jobcode = B.jobcode;

Select A.jobcode,A.part_timed_count,b.full_timed_count
(Select jobcode,count(full_part_time) part_timed_count from job where full_part_time in 'p' group by jobcode) A
(Select jobcode,count(full_part_time) full_timed_count from job where full_part_time in 'f' group by job_code) B where A.jobcode = B.jobcode;