[打卡]张士晨——表通天塔

select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,.locations l where e.department_id=d.department_id and d.location_id=l.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;


SELECT e.last_name,e.salary,j.grade_level
from employees e,job_grades j
where e.salary >= j.lowest_sal and e.salary <= j.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.manager_id=mgr.employee_id;