[打卡]废物管理员

SELECT employee_id,last_name,department_name,city
FROM employees e,departments d,locations l
WHERE e.employee_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 last_name,salary,grade_level
FROM employees,job_grades
WHERE employees.salary >= job_grades.lowest_sal AND employees.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.manager_id = mge.employee_id