How many different professors are there?
SELECT count ( distinct  EMP_NUM )  FROM employee where EMP_JOBCODE = 'PROF'
different professors refers to DISTINCT EMP_NUM; are there refers to a COUNT condition; professors are identified by EMP_JOBCODE = 'PROF';