[打卡]飞哥最帅

SELECT employee_id,last_name,department_name,city
FROM employees e,departments d,locations l
WHERE e.department_id = d.department_id
AND d.department_id = l.location_id;


SELECT * from job_grades;

SELECT e.last_name,e.salary,grade_level
FROM employees e,job_grades j
WHERE e.salary BETWEEN j.lowest_sal AND j.highest_sal;

SELECT * FROM employees;

SELECT e.last_name,e.salary,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.mgnager_id = mgr.employee_id;