[打卡]念燊

select emp.last_name,dep.department_name 
from employees emp,departments dep 
where emp.department_id=dep.department_id;

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 * 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;