[打卡]111

SELECT last_name,department_name from employees, departments
WHERE employees.department_id=departments.department_id;
SELECT*FROM employees;
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;


SELECT*FROM job_grades;
SELECT last_name,salary,grade_level
FROM employees,job_grades
WHERE employees.salary >=job_grades.lowest_sal
AND employees<=job_grades.highest_sal;

SELECT * FROM employees;
SELECT employee_id,last_name,employee_id,last_name
FROM employees emp,employees mgr
WHERE emp.manager_id=mgr.employee_id;