MySQL数据库【习题训练】①

基础查询：

-- 创建emp表

create table emp (
        empno int(11) NOT NULL,-- 员工号
        ename varchar(30) DEFAULT NULL, -- 名字
        job varchar(30) DEFAULT NULL,-- 职位
        mgr int(11) DEFAULT NULL, -- 上司
        hiredate date DEFAULT NULL, -- 出生日期
        sal decimal(6,0) DEFAULT NULL, -- 薪水
        comm decimal(6,0) DEFAULT NULL, -- 绩效
        deptno int(11) DEFAULT NULL, -- 部门号码
        PRIMARY KEY (empno)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 添加数据
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&#