Question

salary_grade departnent dep_id dop_name dep_location INTEGER VARCHAR( 20 ) VARCHAR ( 15 ) 7 grade min_salary max_salary INTEGER INTEGER INTEGER employees emp_id emp_name job_name manager_id hire_date salary commission dep_id INTEGER VARCHAR2(15) VARCHAR2(10) INTEGER DATE DECIMAL(10,2) DECIMAL(7,2) INTEGER

Answer 1

answer)

SELECT employee.emp_id, employee.emp_name, department.dep_location FROM employee, department,salary_grade  WHERE employee.dep_id = department.dep_id AND department.dep_location IN ('PERTH', 'MELBOURNE') AND EXTRACT(YEAR FROM age(CURRENT_DATE, employee.hire_date)) > 5 AND AND employee.salary BETWEEN salary_grade.min_sal AND salary_grade.max_sal AND salary_grade .grade between 3 and 5;