Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

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?

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"