i can’t seem to get my query to run correctly. it shows same last name more than once with more than one grade
i can’t seem to get my query to run correctly. it shows same last name more than once with more than one grade
level and the table only shows that last name once? i tried to attach my file but i don’t think that is working?
so here is my query
select e.last_name , e.job_id, d.department_name, e.salary, .grade_level
from employees e join departments d
on (d.department_id = d.department_id)
join job_grades j
on (e.salary between lowest_sal and highest_sal);
my output shows the same last name 4 times with different grade levels for each name so i am guessing i messed something up?