[打卡]高一鸣---自连接

select employee_id,last_name ,department_name,city 
from employees,departments,locations 
where employees.department_id=departments.department_id 
and departments.location_id=locations.location_id 

select * from job_grades;

select last_name,salary,grade_level 
from employees,job_grades
WHERE employees.salary BETWEEN job_grades.lowest_sal and job_grades.highest_sal;
selct e.last_name,e.salary,j.grade_level
from employees e,
job_grades j 
where e.salary >= j.lowest_sat and e.salary <=job_grades.highest_sal;


select * from employees;

select emp.employee_id,emp.last_name,mgr.employee_id, mgr.last_name
from employees emp ,employees mgr 
where emp. manger_id =mgr.employee_id;

select * from employees;