Thanks Steve!

I guess I was making it more complicated than it needed to be.

The only other part that I'm stuck on is I have to increase the percentage for only those employees with a certain job description BUT....

there are two tables one for job title and one for employees. The table with the job title is the one with the job description but both the job title and employee table have a job_title column. Is this where I combine the tables and use the WHERE clause? Not sure if I'm making much sense to you. But thanks anyways. lol 😀