题目
DROP TABLE IF EXISTS dept;
CREATE TABLE dept(
deptno int PRIMARY KEY ,
dname VARCHAR ( 14 ) ,
loc VARCHAR ( 13 )
) ;
INSERT INTO dept VALUES ( 10 , 'ACCOUNTING' , 'NEW YORK' ) ;
INSERT INTO dept VALUES ( 20 , 'RESEARCH' , 'DALLAS' ) ;
INSERT INTO dept VALUES ( 30 , 'SALES' , 'CHICAGO' ) ;
INSERT INTO dept VALUES ( 40 , 'OPERATIONS' , 'BOSTON' ) ;
DROP TABLE IF EXISTS emp;
CREATE TABLE emp(
empno int PRIMARY KEY ,
ename VARCHAR ( 10 ) ,
job VARCHAR ( 9 ) ,
mgr int ,
hiredate DATE ,
sal double ,
comm double ,
deptno int
) ;
ALTER TABLE emp ADD CONSTRAINT FOREIGN KEY EMP( deptno) REFERENCES dept ( deptno) ;
INSERT INTO emp VALUES ( 7369 , 'SMITH' , 'CLERK' , 7902 , "1980-12-17" , 800 , NULL , 20 ) ;
INSERT INTO emp VALUES ( 7499 , 'ALLEN' , 'SALESMAN' , 7698 , '1981-02-20' , 1600 , 300 , 30 ) ;
INSERT INTO emp VALUES ( 7521 , 'WARD' , 'SALESMAN' , 7698 , '1981-02-22' , 1250 , 500 , 30 ) ;
INSERT INTO emp VALUES ( 7566 , 'JONES' , 'MANAGER' , 7839 , '1981-04-02' , 2975 , NULL , 20 ) ;
INSERT INTO emp VALUES ( 7654 , 'MARTIN' , 'SALESMAN' , 7698 , '1981-09-28' , 1250 , 1400 , 30 ) ;
INSERT INTO emp VALUES ( 7698 , 'BLAKE' , 'MANAGER' , 7839 , '1981-05-01' , 2850 , NULL , 30 ) ;
INSERT INTO emp VALUES ( 7782 , 'CLARK' , 'MANAGER' , 7839 , '1981-06-09' , 2450 , NULL , 10 ) ;
INSERT INTO emp VALUES ( 7788 , 'SCOTT' , 'ANALYST' , 7566 , '1987-07-03' , 3000 , NULL , 20 ) ;
INSERT INTO emp VALUES (