MySQL学习5

MySQL查询练习

创建原始数据库

部门表dept（部门序号，部门名，部门位置）
员工表emp（员工编号，名字，职业，直接上级编号，受雇日期，月薪，补贴，部门序号）
 create database scott;
 use scott；

 CREATE TABLE DEPT
  (DEPTNO INT, 
	DNAME VARCHAR(20), 
	LOC VARCHAR(20), 
	CONSTRAINT PK_DEPT PRIMARY KEY(DEPTNO));


  CREATE TABLE EMP 
  (EMPNO int, 
	ENAME VARCHAR(20), 
	JOB VARCHAR(20), 
	MGR int, 
	HIREDATE DATE, 
	SAL int, 
	COMM int, 
	DEPTNO int, 
	CONSTRAINT PK_EMP PRIMARY KEY(EMPNO),
	CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO)
	REFERENCES DEPT (DEPTNO));
 

Insert into DEPT (DEPTNO,DNAME,LOC) values (10,'ACCOUNTING','NEW YORK');
Insert into DEPT (DEPTNO,DNAME,LOC) values (20,'RESEARCH','DALLAS');
Insert into DEPT (DEPTNO,DNAME,LOC) values (30,'SALES','CHICAGO');
Insert into