[打卡]刘轩玮-课堂作业

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