• change the join in query 1 that I gave you to

    where Employee.JobTitle = JobTitle.JobTitle

    instead of joining on JobDesc