Day_1 (Select Clause) скачать в хорошем качестве

Day_1 (Select Clause)

create table dept( deptno decimal(2,0) not null, dname varchar(14), loc varchar(13)); create table emp( empno decimal(4,0) not null, ename varchar(10), job varchar(9), mgr decimal(4,0), hiredate date, sal decimal(7,2), comm decimal(7,2), deptno decimal(2,0) not null); create table dummy ( dummy decimal); insert into dummy values (0); insert into DEPT (DEPTNO, DNAME, LOC) select 10, 'ACCOUNTING', 'NEW YORK' from dummy union all select 20, 'RESEARCH', 'DALLAS' from dummy union all select 30, 'SALES', 'CHICAGO' from dummy union all select 40, 'OPERATIONS', 'BOSTON' from dummy; insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) select 7839, 'KING', 'PRESIDENT', null, '1981-11-17', 5000, null, 10 union all select 7698, 'BLAKE', 'MANAGER', 7839, '1981-05-01', 2850, null, 30 union all select 7782, 'CLARK', 'MANAGER', 7839, '1981-06-09', 2450, null, 10 union all select 7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975, null, 20 union all select 7902, 'FORD', 'ANALYST', 7566, '1981-12-03', 3000, null, 20 union all select 7369, 'SMITH', 'CLERK', 7902, '1980-12-17', 800, null, 20 union all select 7499, 'ALLEN', 'SALESMAN', 7698, '1981-02-20', 1600, 300, 30 union all select 7521, 'WARD', 'SALESMAN', 7698, '1981-02-22', 1250, 500, 30 union all select 7654, 'MARTIN', 'SALESMAN', 7698, '1981-09-28', 1250, 1400, 30 union all select 7844, 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500, 0, 30 union all select 7900, 'JAMES', 'CLERK', 7698, '1981-12-03', 950, null, 30 union all select 7934, 'MILLER', 'CLERK', 7782, '1982-01-23', 1300, null, 10 union all select 7788, 'SCOTT', 'ANALYST', 7566, '1987-07-13', 3000, null, 20 union all select 7876, 'ADAMS', 'CLERK', 7788, '1987-07-13', 1100, null, 20 ;