数据库入门第二次作业---分组查询练习

分组练习.sql
百度网盘链接：
链接：https://pan.baidu.com/s/11Ai_cKSOPRcS0TATTcdWAA
提取码：ox7k
复制这段内容后打开百度网盘手机App，操作更方便哦
/*
MySQL Data Transfer
Source Host: localhost
Source Database: teacherdb
Target Host: localhost
Target Database: teacherdb
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for dept

---

DROP TABLE IF EXISTS dept;
CREATE TABLE dept (
DEPTNO int(11) NOT NULL AUTO_INCREMENT,
DNAME varchar(14) DEFAULT NULL,
LOC varchar(13) DEFAULT NULL,
PRIMARY KEY (DEPTNO)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4;

---

– Table structure for emp

---

DROP TABLE IF EXISTS emp;
CREATE TABLE emp (
EMPNO int(11) NOT NULL AUTO_INCREMENT,
ENAME varc