123

SELECT last_name,department_name
FROM employees,departments
WHERE employees.department_id=departments.department_id;

 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 last_name,salary,grade_level
 FROM employees,job_grades
 WHERE employees.salary>=job_grades.lowest_sal AND employees.salary