11-SQ语句测试题3.docVIP

以下各个题目将用到上图的4个表，其关联关系如图所示。这个四个表中字段的具体情况参看如下内容： EMPLOYEES(employee_id number(6) not null,first_name varchar2(20),last_name varchar2(25) not null,email varchar2(25) not null,phone_number varchar2(20),hire_date date not null,job_id varchar2(10) not null,salary number(8,2),commission_pct number(2,2),manager_id number(6),department_id number(4)) DEPT(department_id number(4) not null,department_name varchar2(30) not null,manager_id number(6),location_id number(4)) locations(location_id number(4) not null,city varchar2(20)) job_grades(grade_level varchar2(3),lowest_sal number,highest_sal number) EMP