正在学习MySQL的你，需要练习题吗？

ゝ一世哀愁。 2023-05-28 11:30 2阅读 0赞

*  下面是MySQL基础知识的练习题，涵盖DDL、DML、DCL、列的约束、关键字、函数、条件筛选、排序、分组、嵌套、联合查询、分页查询…
 *  无论是数据库、表格的创建、修改和删除（DDL），还是表格的增删改查（DML），这些都是基础中的基础；练习题目中涉及到的知识点随着目录递进

# 小练习一：条件筛选、排序 #

创建一个person表，共有四个列（字段），并向表中插入数据，

create table person(
    	username varchar(20),
    	address varchar(20),
    	salary int(10),
    	department varchar(20)
    )character set utf8;

insert into person values('张三','武当',6000,'保洁部');
    insert into person values('张无忌','魔教',6000,'事业部');
    insert into person values('张三丰','武当',4000,'产业部');
    insert into person values('周芷若','峨眉',8000,'事业部');
    insert into person values('谢逊','魔教',5000,'产业部');
    insert into person values('杨逍','魔教',7000,'事业部');

person表格：  
![在这里插入图片描述][20190610211646836.png]

1.  假设person表中所有人每个月还有100元的奖金，查询出所有人的姓名、地址、年薪

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70]

1.  假设person表中所有人每年还有1000元的奖金，查询出所有人的姓名、地址、年薪

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 1]

1.  请以下面的方式查询出所有信息：

姓名 居住地 月薪 年薪  
张三 武当 6000 72000

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 2]

1.  请查询出所有部门为事业部的所有人信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 3]

1.  请查询出所有地址为魔教的所有人信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 4]

1.  请查询出所有工资为6000元的人的所有信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 5]

1.  请查询出所有工资在6000-8000之间的所有人的信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 6]

1.  请查询出所有工资是6000，7000，8000的所有人的信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 7]

1.  请查询出所有工资在6000-8000之间，或者姓张的所有人的基本信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 8]

1.  请查询出所有工资为6000，7000，8000，或者姓张，并且不叫张三丰的所有人的基本信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 9]

1.  请查询出所有工资为5000，或者叫张三的人的所有信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 10]

1.  请查询出所有魔教的人的信息，按照人名升序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 11]

1.  请查询出所有工资高于5000的人员信息，按照address降序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 12]

1.  请查询出所有人的信息，先按照salary降序排列，若一致，则按照人名升序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 13]

# 小练习二：分组、函数的使用 #

先创建一个Users表格

create table users(
    	员工编号 int(5),
    	姓名 varchar(20),
    	部门 varchar(20),
    	生日 date,
    	工资 int(10),
    	职务 varchar(20),
    	信息更新时间 date
    )character set utf8;

insert into users values(1,'赵一一','C','1980-10-11',10000,'程序员',now());
    insert into users values(2,'钱二二','C','1981-10-12',20000,'程序员',now());
    insert into users values(3,'孙三三','C','1982-09-01',30000,'项目经理',now());
    insert into users values(4,'李四四','java','1983-09-02',40000,'程序员',now());
    insert into users values(5,'周五五','java','1984-11-01',50000,'程序员',now());
    insert into users values(6,'吴六六','java','1985-01-01',60000,'程序员',now());
    insert into users values(7,'郑七七','java','1986-11-02',70000,'项目经理',now());

users表：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 14]

1.  请建立users表保存员工的相关信息（生日，信息更新时间 用date类型）
2.  查询每个部门的最高工资，最低工资，平均工资

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 15]

1.  给所有项目经理工资涨10000

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 16]

1.  给工资低于30000的员工工资涨到30000

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 17]

1.  查询各部门的工资总额，平均工资，最高工资，最低工资

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 18]

1.  c部门的项目经理离职，删除其信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 19]

1.  c部门的程序员全部转入Java部门，更改信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 20]

1.  查询11月份过生日的员工

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 21]

1.  查询本月过生日的员工。设计一个通用的语句

![在这里插入图片描述][20190611193724754.png]  
（补充：我进行查询的时候是6月份）

1.  查询整合部门后表中记录的所有记录，按照薪资从高到低排布

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 22]

# 小练习三 #

--------------------

## 创建两个表格：emp、dept ##

**emp员工表**

create table emp(
    empno int(10),	//编号
    ename varchar(12),	//姓名
    job varchar(20),	//职务
    mgr int(10),	//上级
    hiredare date,	//入职日期
    sal int(10),	//月薪
    comm int(10),	//佣金
    depno int(5)	//部门
    );

**在emp表中添加数据：**

insert into emp values(7369,'smith','clerk',7902,'1980-12-17',800,null,20);
    insert into emp values(7499,'allen','salesman',7698,'1981-2-20',1600,300,30);
    insert into emp values(7521,'ward','salesman',7698,'1981-2-22',1250,500,30);
    insert into emp values(7566,'jones','manager',7839,'198-4-2',2975,null,20);
    insert into emp values(7654,'martin','salesman',7698,'1981-9-28',1250,1400,30);
    insert into emp values(7698,'blake','manager',7839,'1981-5-1',2850,null,30);
    insert into emp values(7782,'clark','manager',7839,'1981-6-9',2450,null,10);
    insert into emp values(7788,'scott','analyst',7566,'1987-4-19',3000,null,20);
    insert into emp values(7839,'king','president',null,'1981-11-17',5000,null,10);
    insert into emp values(7844,'turner','salesman',7698,'1981-9-8',1500,0,30);
    insert into emp values(7876,'adams','clerk',7788,'1987-5-23',1100,null,20);
    insert into emp values(7900,'james','clerk',7698,'1981-12-3',950,null,30);
    insert into emp values(7902,'ford','analyst',7566,'1981-12-3',3000,null,20);
    insert into emp values(7934,'miller','clerk',7782,'1982-1-23',1300,null,10);

emp表：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 23]

**dept部门表**

create table dept(
    deptno int(5),	//部门编号
    dname varchar(20),	//部门名称
    loc varchar(20)	//坐落城市
    );

添加数据

insert into dept values(10,'accounting','new york');
    insert into dept values(20,'research','dallas');
    insert into dept values(30,'sales','new chicago');
    insert into dept values(40,'operations','boston');

dept表：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 24]

## 条件筛选题（emp表） ##

1.  查询部门30中的雇员

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 25]

1.  查询所有办事员（clerk）的姓名、编号和部门

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 26]

1.  查询佣金（comm）高于薪金（sal）的雇员

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 27]

1.  查询哪些人没有佣金（comm）

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 28]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 29]

1.  查询佣金（comm）高于薪金（sal）60%的雇员

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 30]

1.  显示所有人的姓名，月薪，年薪（取别名）

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 31]

1.  找出部门10中的所有经理和部门20中的所有办事员的详细资料

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 32]

1.  找出部门10中所有经理、部门20中所有办事员，既不是经理又不是办事员，但其薪金大于等于2000的所有雇员的资料

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 33]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 34]

1.  找出不收取佣金或收取佣金低于500的雇员

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 35]

## 排序练习（emp表） ##

1.  查询所有人员信息，按照工资升序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 36]

1.  查询所有人员姓名，工资，佣金，按照工资降序排列，若工资相同则按照佣金升序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 37]

1.  查询工资大于2000的所有员工，按照工资薪金降序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 38]

1.  查询所有人的信息，按照姓名排序

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 39]

1.  查询工资在2000-3000之间的员工信息，按照雇佣日期升序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 40]

## 函数练习（emp表） ##

1.  显示正好为6个字符的雇员姓名

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 41]

1.  显示所有雇员的姓名的前三个字符

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 42]

1.  显示所有雇员的姓名，用A代替‘a’

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 43]

1.  显示不带有‘r’的雇员姓名

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 44]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 45]

1.  找出早于35年之前受雇的雇员

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 46]  
（补充：查询时是2019年）

1.  显示所有雇员的姓名以及满10年服务年限的日期

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 47]

## 分组函数练习（emp表） ##

1.  显示每种工作的人数

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 48]

1.  显示工作人数大于3的工作的平均工资

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 49]

1.  显示出经理有几种不同的工资

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 50]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 51]

1.  显示出30号部门有几种不同的工作

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 52]

1.  显示出emp表数据中不同月份雇佣的人数

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 53]

1.  显示出每个管理者手下带了多少个员工

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 54]

1.  显示收取佣金的雇员的不同工作

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 55]

## 嵌套查询练习（emp表） ##

1.  查询平均工资大于2900的部门中的所有员工

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 56]

1.  查询工资比allen多的所有员工

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 57]

1.  查询薪金高于公司平均薪金的所有员工姓名，部门编号，具体薪资

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 58]

1.  列出与scott从事相同工作的所有员工信息

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 59]

1.  查询薪金大于部门30中的员工最高薪金的所有员工的姓名、薪金和部门编号

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 60]

1.  查询在部门sales工作的员工的姓名

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 61]

# 小练习四：表格之间的联合查询 #

先创建三张表格

**country表（存储国家信息）：**

create table country(
    cid int(5),
    cname varchar(20)
    )character set utf8;
    
    alter table country add primary key(cid);
    
    insert into country values(1,'中国');
    insert into country values(2,'美国');
    insert into country values(3,'日本');

![在这里插入图片描述][20190616164252304.png]

**area表（存储地区信息）：**

create table area(
    aid int(5),
    aname varchar(20),
    cid int(5)
    )character set utf8;
    
    alter table area add primary key(aid);
    alter table area add constraint fk_area_country foreign key(cid) references country(cid);
    
    insert into area values(1,'北方',1);
    insert into area values(2,'南方',1);
    insert into area values(3,'西部',2);
    insert into area values(4,'东部',2);
    insert into area values(5,'北海道',3);
    insert into area values(6,'四国',3);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 62]  
**city表（存储城市信息）：**

create table city(
    cityid int(5),
    cityname varchar(20),
    citysize int(10),
    aid int(5)
    )character set utf8;
    
    alter table city add primary key(cityid);
    alter table city add constraint fk_city_area foreign key(aid) references area(aid);
    
    insert into city values(1,'哈尔滨',750,1);
    insert into city values(2,'大连',50,1);
    insert into city values(3,'北京',2000,1);
    insert into city values(4,'上海',1500,2);
    insert into city values(5,'杭州',800,2);
    insert into city values(6,'洛杉矶',1200,3);
    insert into city values(7,'休斯顿',750,3);
    insert into city values(8,'纽约',1000,4);
    insert into city values(9,'底特律',500,4);
    insert into city values(10,'东京',1500,5);
    insert into city values(11,'名古屋',50,5);
    insert into city values(12,'大阪',20,6);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 63]

--------------------

1.  查询人口数在1000到2000之间的城市所属在哪个地区

涉及到两张表city和area

select distinct aname 
    from city inner join area 
    on city.aid = area.aid  
    where city.citysize between 1000 and 2000;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 64]

1.  查询每个国家的城市个数，按照城市个数升序排列

涉及到三张表country，area，city

select cname, count(city.cityid) as citycount 
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    group by cname 
    order by citycount asc;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 65]

1.  查询各地区城市人口平均数，按照人口平均数降序排列

涉及到两张表area和city

select aname, avg(citysize) as avg 
    from area inner join city on area.aid = city.aid 
    group by aname 
    order by avg desc;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 66]  
4. 查询哈尔滨所在的国家的名字

涉及到三张表

select cityname,cname  
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    where cityname = '哈尔滨';

![在这里插入图片描述][20190616171822859.png]  
5. 查询各地区名字和人口总数

涉及到两张表area和city

select aname,sum(citysize) as sum 
    from area inner join city on area.aid = city.aid  
    group by aname;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 67]  
6. 查询美国有哪些城市，列出城市名

涉及到三张表

select cityname 
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    where cname = '美国';

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 68]  
7. 查询人口最多的城市在哪个国家

涉及到三张表

select cityname,cname 
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    where citysize = (select max(citysize) from city);

![在这里插入图片描述][20190616173045372.png]  
8. 查询每个国家的人口总数

涉及到三张表

select cname,sum(citysize) as sum   
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    group by cname;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 69]  
9. 查询城市人口总数为1500万的国家名字

涉及到三张表

select cname,cityname,citysize    
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    where citysize = 1500;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 70]

1.  查询各地区总人数，按照人口总数降序排列

涉及到两张表area和city

select aname,sum(citysize) as sum 
    from area inner join city on area.aid = city.aid 
    group by aname 
    order by sum desc;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 71]

1.  查询人口总数超过5000的国家名称

设计三张表

select cname,sum(citysize)    
    from country inner join area on country.cid = area.cid inner join city on area.aid = city.aid 
    group by cname 
    having sum(citysize) > 5000;

（注意：这一题，要先分组，再条件筛选，所以用`having`关键字）  
![在这里插入图片描述][20190616174234866.png]  
12. 查询人口数大于杭州的城市都有哪些

只涉及到city表

select cityname 
    from city 
    where citysize > (select citysize from city where cityname = '杭州');

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 72]

# MySQL综合练习：来挑战一下 #

--------------------

## 题目描述 ##

1.  设有一个数据库,包括四个表:

*  学生表(student),
 *  课程表(course),
 *  成绩表(score),
 *  教师信息表(teacher).

1.  表结构如表1-1的表(一)~表(四)所示.
2.  表内数据如表1-2的表(一)~表(四)所示.
3.  用SQL语句创建四个表并完成相关题目.

表1-1数据库的表结构  
表(一)student

<table> 
 <thead> 
  <tr> 
   <th>属性名</th> 
   <th>数据类型</th> 
   <th>含 义</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>sno</td> 
   <td>int</td> 
   <td>学号(主键)</td> 
  </tr> 
  <tr> 
   <td>sname</td> 
   <td>varchar</td> 
   <td>学生姓名</td> 
  </tr> 
  <tr> 
   <td>ssex</td> 
   <td>varchar</td> 
   <td>学生性别</td> 
  </tr> 
  <tr> 
   <td>sbirthday</td> 
   <td>date</td> 
   <td>学生出生年月</td> 
  </tr> 
  <tr> 
   <td>classid</td> 
   <td>varchar</td> 
   <td>学生所在班级</td> 
  </tr> 
 </tbody> 
</table>

表(二)course

<table> 
 <thead> 
  <tr> 
   <th>属性名</th> 
   <th>数据类型</th> 
   <th>含 义</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>cno</td> 
   <td>varchar</td> 
   <td>课程号(主键)</td> 
  </tr> 
  <tr> 
   <td>cname</td> 
   <td>varchar</td> 
   <td>课程名称</td> 
  </tr> 
  <tr> 
   <td>tno</td> 
   <td>int</td> 
   <td>教师编号(外键)</td> 
  </tr> 
 </tbody> 
</table>

表(三)score

<table> 
 <thead> 
  <tr> 
   <th>属性名</th> 
   <th>数据类型</th> 
   <th>含 义</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>sno</td> 
   <td>int</td> 
   <td>学号(外键)</td> 
  </tr> 
  <tr> 
   <td>cno</td> 
   <td>varchar</td> 
   <td>课程号(外键)</td> 
  </tr> 
  <tr> 
   <td>sdegree</td> 
   <td>float</td> 
   <td>成绩</td> 
  </tr> 
 </tbody> 
</table>

表(四) teacher

<table> 
 <thead> 
  <tr> 
   <th>属性名</th> 
   <th>数据类型</th> 
   <th>含 义</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>tno</td> 
   <td>int</td> 
   <td>编号(主键)</td> 
  </tr> 
  <tr> 
   <td>tname</td> 
   <td>varchar</td> 
   <td>教师姓名</td> 
  </tr> 
  <tr> 
   <td>tsex</td> 
   <td>varchar</td> 
   <td>教师性别</td> 
  </tr> 
  <tr> 
   <td>tbirthday</td> 
   <td>date</td> 
   <td>教师出生年月</td> 
  </tr> 
  <tr> 
   <td>professional</td> 
   <td>varchar</td> 
   <td>职称</td> 
  </tr> 
  <tr> 
   <td>department</td> 
   <td>varchar</td> 
   <td>教师所在部门</td> 
  </tr> 
 </tbody> 
</table>

表1-2数据库中的数据

表(一)student

<table> 
 <thead> 
  <tr> 
   <th>sno</th> 
   <th>sname</th> 
   <th>ssex</th> 
   <th>sbirthday</th> 
   <th>classid</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>108</td> 
   <td>曾华</td> 
   <td>男</td> 
   <td>1996-09-01</td> 
   <td>95033</td> 
  </tr> 
  <tr> 
   <td>105</td> 
   <td>匡明</td> 
   <td>男</td> 
   <td>1995-10-02</td> 
   <td>95031</td> 
  </tr> 
  <tr> 
   <td>107</td> 
   <td>王丽</td> 
   <td>女</td> 
   <td>1996-01-23</td> 
   <td>95033</td> 
  </tr> 
  <tr> 
   <td>101</td> 
   <td>李军</td> 
   <td>男</td> 
   <td>1996-02-20</td> 
   <td>95033</td> 
  </tr> 
  <tr> 
   <td>109</td> 
   <td>王芳</td> 
   <td>女</td> 
   <td>1995-02-10</td> 
   <td>95031</td> 
  </tr> 
  <tr> 
   <td>103</td> 
   <td>陆君</td> 
   <td>男</td> 
   <td>1994-06-03</td> 
   <td>95031</td> 
  </tr> 
 </tbody> 
</table>

表(二)course

<table> 
 <thead> 
  <tr> 
   <th>cno</th> 
   <th>cname</th> 
   <th>tno</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>3-105</td> 
   <td>计算机导论</td> 
   <td>825</td> 
  </tr> 
  <tr> 
   <td>3-245</td> 
   <td>操作系统</td> 
   <td>804</td> 
  </tr> 
  <tr> 
   <td>6-166</td> 
   <td>数字电路</td> 
   <td>856</td> 
  </tr> 
  <tr> 
   <td>9-888</td> 
   <td>高等数学</td> 
   <td>831</td> 
  </tr> 
 </tbody> 
</table>

表(三)score

<table> 
 <thead> 
  <tr> 
   <th>sno</th> 
   <th>cno</th> 
   <th>sdegree</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>103</td> 
   <td>3-245</td> 
   <td>86</td> 
  </tr> 
  <tr> 
   <td>105</td> 
   <td>3-245</td> 
   <td>75</td> 
  </tr> 
  <tr> 
   <td>109</td> 
   <td>3-245</td> 
   <td>68</td> 
  </tr> 
  <tr> 
   <td>103</td> 
   <td>3-105</td> 
   <td>92</td> 
  </tr> 
  <tr> 
   <td>105</td> 
   <td>3-105</td> 
   <td>88</td> 
  </tr> 
  <tr> 
   <td>109</td> 
   <td>3-105</td> 
   <td>76</td> 
  </tr> 
  <tr> 
   <td>101</td> 
   <td>3-105</td> 
   <td>64</td> 
  </tr> 
  <tr> 
   <td>107</td> 
   <td>3-105</td> 
   <td>91</td> 
  </tr> 
  <tr> 
   <td>108</td> 
   <td>3-105</td> 
   <td>78</td> 
  </tr> 
  <tr> 
   <td>101</td> 
   <td>6-166</td> 
   <td>85</td> 
  </tr> 
  <tr> 
   <td>107</td> 
   <td>6-166</td> 
   <td>79</td> 
  </tr> 
  <tr> 
   <td>108</td> 
   <td>6-166</td> 
   <td>81</td> 
  </tr> 
 </tbody> 
</table>

表(四) teacher

<table> 
 <thead> 
  <tr> 
   <th>tno</th> 
   <th>tname</th> 
   <th>tsex</th> 
   <th>tbirthday</th> 
   <th>prof</th> 
   <th>depart</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>804</td> 
   <td>李诚</td> 
   <td>男</td> 
   <td>1978-12-02</td> 
   <td>副教授</td> 
   <td>计算机系</td> 
  </tr> 
  <tr> 
   <td>856</td> 
   <td>张旭</td> 
   <td>男</td> 
   <td>1979-03-12</td> 
   <td>讲师</td> 
   <td>电子工程系</td> 
  </tr> 
  <tr> 
   <td>825</td> 
   <td>王萍</td> 
   <td>女</td> 
   <td>1982-05-05</td> 
   <td>助教</td> 
   <td>计算机系</td> 
  </tr> 
  <tr> 
   <td>831</td> 
   <td>刘冰</td> 
   <td>女</td> 
   <td>1984-08-14</td> 
   <td>助教</td> 
   <td>电子工程系</td> 
  </tr> 
 </tbody> 
</table>

--------------------

## 创建数据库和四张表 ##

> 先创建数据库：julyone  
> 并且设置这个数据库的编码字符集为utf-8  
> ![在这里插入图片描述][20190706155641796.png]  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 73]

student表：

create table student(
    	sno  int(10),
    	sname varchar(10),
    	ssex varchar(10),
    	sbirthday date,
    	classid varchar(10)
    );
    
    alter table student add primary key(sno);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 74]  
teacher表：

create table teacher(
    	tno int(10),
    	tname varchar(12),
    	tsex varchar(10),
    	tbirthday date,
    	professional varchar(20),
    	department varchar(20)
    );
    
    alter table teacher add primary key(tno);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 75]

course表：

create table course(
    	cno varchar(10),
    	cname varchar(20),
    	tno int(10)
    );
    
    alter table course add primary key(cno);
    alter table course add constraint fk_course_teacher foreign key(tno) references teacher(tno);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 76]  
score表：

create table score(
    	sno int(10),
    	cno varchar(10),
    	sdegree float(5)
    );
    
    alter table score add constraint fk_score_student foreign key(sno) references student(sno);
    alter table score add constraint fk_score_course foreign key(cno) references course(cno);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 77]

--------------------

## 向表中插入数据 ##

> 然后向表中插入数据

insert into student (sno,sname,ssex,sbirthday,classid) 
    values(108,'曾华','男','1996-9-1','95033'),(105,'匡明','男','1995-10-2','95031'),
    (107,'王丽','女','1996-1-23','95033'),(101,'李军','男','1996-2-20','95033'),
    (109,'王芳','女','1995-2-10','95031'),(103,'陆君','男','1994-6-3','95031');
    
    
    insert into teacher(tno,tname,tsex,tbirthday,professional,department) 
    values(804,'李诚','男','1978-12-2','副教授','计算机系'),
    (856,'张旭','男','1979-3-12','讲师','电子工程系'),
    (825,'王萍','女','1982-5-5','助教','计算机系'),
    (831,'刘冰','女','1984-8-14','助教','电子工程系');
    
    
    insert into course(cno,cname,tno) 
    values('3-105','计算机导论',825),('3-245','操作系统',804),
    ('6-166','数字电路',856),('9-888','高等数学',831);
    
    
    insert into score(sno,cno,sdegree) values
    (103,'3-245',86),
    (105,'3-245',75),
    (109,'3-245',68),
    (103,'3-105',92),
    (105,'3-105',88),
    (109,'3-105',76),
    (101,'3-105',64),
    (107,'3-105',91),
    (108,'3-105',78),
    (101,'6-166',85),
    (107,'6-166',79),
    (108,'6-166',81);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 78]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 79]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 80]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 81]

--------------------

## SQL题目 ##

– 1.查询所有学生的姓名,性别及班级编号  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 82]

– 2.查询教师所有的部门名称,(即不重复的DEPART列)  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 83]

– 3.查询STUDENT表的所有记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 84]  
– 4.查询SCORE表中成绩在60到80之间的所有记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 85]  
– 5.查询SCORE表中成绩为85,86或88的记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 86]  
– 6.查询STUDENT表中班级编号为"95031"或性别为"女"的同学记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 87]

– 7.查询STUDENT表的所有记录,以班级编号降序排列  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 88]

– 8.查询SCORE表的所有记录,先按照CNO升序排列,若相同则按照SDEGREE降序排列

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 89]  
– 9.查询班级编号为"95031"班级的学生人数

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 90]  
– 10.查询SCORE表中的最高分的学生学号和课程号  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 91]  
– 11.查询编号为"3-105"的课程平均分  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 92]

– 12.查询SCORE表中至少有5名学生选修的并以3开头的课程的平均分数  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 93]  
– 13.查询每科成绩均在70到90之间的学生编号  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 94]

– 14.查询所有学生的姓名,所选课程编号和成绩  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 95]

– 15.查询所有学生的学号,所选课程名和成绩  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 96]

– 16.查询所有学生的姓名,所选课程名和成绩  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 97]

– 17.查询"95033"班同学所选每个课程的平均分  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 98]

– 18.假设使用如下命令建立了一个GRADE表：  
CREATE TABLE GRADE(  
LOW INT(3),  
UPP INT(3),  
RANK VARCHAR(1)  
);  
INSERT INTO GRADE VALUES(90,100,‘A’);  
INSERT INTO GRADE VALUES(80,89,‘B’);  
INSERT INTO GRADE VALUES(70,79,‘C’);  
INSERT INTO GRADE VALUES(60,69,‘D’);  
INSERT INTO GRADE VALUES(0,59,‘E’);  
– 现查询所有同学的学号,所选课程号和等级(RANK列)  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 99]  
– 19.查询"3-105"课程的成绩高于学号为109同学这科成绩的所有同学记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 100]  
– 20.查询1995年之后出生的所有学生所选学的课程名及成绩  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 101]  
– 21.查询与学号108同学同年出生的所有学生的学号,姓名和生日  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 102]  
– 22.查询"张旭"教师任课的学生成绩  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 103]  
– 23.查询选修某课程的同学人数多于5人的教师姓名  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 104]  
– 24.查询"95033"班和"95031"班全体学生的记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 105]  
– 25.查询存在有85分以上成绩的课程编号  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 106]  
– 26.查询出"计算机系"教师所教课程每一科成绩的平均分  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 107]  
– 27.**查询"计算机系"与"电子工程系"不同职称的教师的姓名和职称**

（这个题目的逻辑有点复杂啊）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 108]  
– 28.查询所有教师和同学的姓名,性别和生日  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 109]  
– 29.查询所有"女"教师和"女"同学的姓名,性别和生日  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 110]  
– 30.查询所有任课教师的姓名和部门  
![在这里插入图片描述][2019070618540114.png]  
– 31.查询所有未讲课的教师的姓名和部门  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 111]  
– 32.查询STUDENT表中不姓"王"的同学记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 112]  
– 33.查询STUDENT表中每个学生的姓名和年龄  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 113]  
– 34.查询STUDENT表中最大和最小的生日值  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 114]  
– 35.查询STUDENT表中的全部记录,按照班级编号降序排列,班级编号若相同则按照生日降序排列  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 115]  
– 36.查询所有"男"教师及其所上的课程名称  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 116]  
– 37.查询和"李军"同性别并同班的同学信息  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 117]  
– 38.查询所有选修"计算机导论"课程的"男"同学的成绩表  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 118]  
– 39.查询出同时选择"3-245"和"3-105"的课程的学生信息  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 119]  
– 40.**查询既没有选修"3-245"课程也没有选修"3-105"课程的学生信息**

注意：这个题目超级坑！！！答案是没有查询结果，empty

我很容易的就进坑了：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 120]  
因为每个数据都是单独的！  
score表中的这三条记录满足上述SQL语句的查询条件：  
![在这里插入图片描述][20190706205420451.png]  
但是101，107，108都选修了3-245或者-105的课程，于是问题就这么产生了。

然后，我思考良久，未果，打游戏。

不过硬要答案的话：  
凑合着看吧（来一个巧合性的SQL语句）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 121]  
最终智慧：  
![在这里插入图片描述][20190707153017264.png]

[20190610211646836.png]: /images/20230528/d951ada3ea4d4cb09519974edff3f71a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70]: /images/20230528/16b42825a4834bc4a9528ff5f50fe419.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 1]: /images/20230528/b96a6b189c5946f08bf5d1027bb83bd9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 2]: /images/20230528/0586af6baa8946a29a6e61acb7caa814.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 3]: /images/20230528/4f6be46f37b14692a2a3b1dee4456f39.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 4]: /images/20230528/83f2c61478fe4cf4936a6422644b3cbe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 5]: /images/20230528/a3b4c24152244758b6da1f11eb369ba5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 6]: /images/20230528/ad67f8d74cd4450cbfe87d5333bca5ee.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 7]: /images/20230528/3d72240c7356402aa453b02a1fe53031.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 8]: /images/20230528/e463b0efab1f43e49cd682d33e7e8017.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 9]: /images/20230528/418c88cb066641adb72d79a1457f55dc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 10]: /images/20230528/2897760250b64cbeae67d70f7d3bb1ca.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 11]: /images/20230528/085c94c97a2142c6869e404ecca4229c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 12]: /images/20230528/ec5605fd6e384054ae9a3e1c6091c552.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 13]: /images/20230528/5351d0a7700d4e70857b45f9f8f95feb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 14]: /images/20230528/6a2cfec7dfe6499ebc53ec4cc9b5c800.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 15]: /images/20230528/177eb048c94e465797e93bb20ec0a2df.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 16]: /images/20230528/b049b88e555f4c7a921356f89e5f931e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 17]: /images/20230528/9f8fa5187856490baea321c2c9e477d9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 18]: /images/20230528/546a0aaf39a84203ae473c88e1022066.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 19]: /images/20230528/28d323b807c1422ea3a26d94ad2a5c57.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 20]: /images/20230528/cc458b8681f54779acf0549bce0e01fa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 21]: /images/20230528/2995361f178c402b8c20a88c65da46c1.png
[20190611193724754.png]: /images/20230528/1c14f3b23d014f99a2908a3ce41d29d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 22]: /images/20230528/561cb7785eaf4f3eb070ee0a397af4eb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 23]: /images/20230528/91ddb3d778f846a3badb81edd79126ca.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 24]: /images/20230528/a46cc4efab6e4a909c13b0713125d8b6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 25]: /images/20230528/98f682c881d445fa8ab8e6cb94e2f870.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 26]: /images/20230528/133e0762e99a4f6b99ee0ee809e69473.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 27]: /images/20230528/3dc07d302e484d1989051ef364f51a56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 28]: /images/20230528/e6dad7ff36a744088e78e72957c56e0d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 29]: /images/20230528/575acd9143ac495e9ec2c41aeb329e08.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 30]: /images/20230528/09dac71bd99c4084b244c9b361d104be.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 31]: /images/20230528/7365b42e502e47afb00d94543a427954.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 32]: /images/20230528/d3c767986c23423d8b24f9585c512199.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 33]: /images/20230528/5a379d0a7ad143a987f59eb60a0ded34.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 34]: /images/20230528/5d6ac1ccbd6d4ffb93ad6d534b96eab1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 35]: /images/20230528/3ec6f05bc044451e9d217c3e6b69f1db.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 36]: /images/20230528/fa38b18b577e4e2bbcbe27544ebf0bf2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 37]: /images/20230528/6c629618e0154af0a3a933a6fdc7442c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 38]: /images/20230528/f9059c3d068b4d92976f4c33f7e0cede.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 39]: /images/20230528/386fb73b1f634a18bb537d52bf1fef2d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 40]: /images/20230528/deb70fdbc29e4c1b91c305c6e44969df.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 41]: /images/20230528/1f2007bd9ef24924ae8e4ad1f4dc9212.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 42]: /images/20230528/bdd0e9f890c7435eb3230ffc92e4ee43.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 43]: /images/20230528/e267849e5e3a4554a24ba89dda82c97a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 44]: /images/20230528/4ca21e9aece444c18cc0c8a90c9d1c50.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 45]: /images/20230528/7eb2a919722b43cd8bf27b3b4eb9b0a4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 46]: /images/20230528/4f528ddfc66b4a6088029574f43c4518.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 47]: /images/20230528/ccd86341e946439c9795c8781b33a4b7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 48]: /images/20230528/0cd752f21b9b4d77af3d07d208262b6c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 49]: /images/20230528/e30629c3b71c41738d6ca2e5c95d221c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 50]: /images/20230528/109f9e4c04814acba94a20c213f1d2f0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 51]: /images/20230528/bed1f43b53354604ae95e3f0377588ce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 52]: /images/20230528/0d25f80d200e44acbda4acca2116d41a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 53]: /images/20230528/c799942790504acfb8e6e1ee19c52c20.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 54]: /images/20230528/7aeb88acc43e4bec87cc0fb404791d56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 55]: /images/20230528/d0863b1f228343a68dcc3a9f04109c49.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 56]: /images/20230528/278bf6c808d142de939d318ae5a241e2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 57]: /images/20230528/fca150ad8084446e9f01483d8392aa79.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 58]: /images/20230528/4ae4bdd0e57c4c3ea9d7bd841e708e2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 59]: /images/20230528/23e71481a40644edba6b6ab28b4f3d2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 60]: /images/20230528/f24855098f244a7986b2ebdf26436d79.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 61]: /images/20230528/9d6dbff558064e4b93eaaa58deb45391.png
[20190616164252304.png]: /images/20230528/e0121a4f5aa448c1ac5aed075af33cc3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 62]: /images/20230528/f7ac64c3f28645a091ae5cb5f2624c09.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 63]: /images/20230528/41d995abfa474b2bb4da2e12318ee3c1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 64]: /images/20230528/ff3138c0830d4fd3b444c8c7e8c32b78.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 65]: /images/20230528/276c6c4c70484066b969e974fabc70c1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 66]: /images/20230528/5be6bd7d034d409f99bf012b1070cdd0.png
[20190616171822859.png]: /images/20230528/ee151e7484a14b8fac8ab17392f15ac7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 67]: /images/20230528/0a4401b26ab54e208507d7ce4d861ccb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 68]: /images/20230528/3647d8dca07e44dfb9f84fe4f62b3b95.png
[20190616173045372.png]: /images/20230528/f1ace9f22f2f49309a5526371b367ef1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 69]: /images/20230528/63f14b7d0e5f49c08c6f2ae0c546a8eb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 70]: /images/20230528/09488d5e46da402da64d2b58c7d2b97c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 71]: /images/20230528/e4096b9e1ce94504a300632a79395bb4.png
[20190616174234866.png]: /images/20230528/18fe13a0dbc04f9983a6608ccfd5191c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 72]: /images/20230528/b13c198eba404d378f27397021f3b45f.png
[20190706155641796.png]: /images/20230528/dae3cdc234e64e5198259ef0a7bab9b8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 73]: /images/20230528/93e20b46213546f6b6c2a07c67e5f5ff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 74]: /images/20230528/d97559a75c434561b921a4109fbefb42.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 75]: /images/20230528/4c5c28243f594bcf8d7407eeedac5daf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 76]: /images/20230528/d9ffb551ca59451ba424e1c4e275643f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 77]: /images/20230528/a89ddda89a574c8da27424ef64e8358a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 78]: /images/20230528/d05d0785f9274c9b9eb180c1e29ade16.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 79]: /images/20230528/309f0ff754614b4bb4e1acd870649c26.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 80]: /images/20230528/12f73db32875420b809da6175eeba5c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 81]: /images/20230528/15b798d76b6345299f3394bca05f6a17.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 82]: /images/20230528/dfa09fad142c48b69e48588a1eda3d69.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 83]: /images/20230528/f77bb34f7cd54b998021cbcccc85efa1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 84]: /images/20230528/e53ca8b3e9a54c008b74ad10b152e61b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 85]: /images/20230528/3af44486b4274798a0bd32cd9f9560fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 86]: /images/20230528/f3c6135372ce48ec8e9b41664f6164b5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 87]: /images/20230528/bbe3e2f0220144e685e13c85ee0d1373.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 88]: /images/20230528/4536520e07fd4b6c8edaf2abc8b4c000.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 89]: /images/20230528/6bd44088822743fb9c2b5c7ec299eadb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 90]: /images/20230528/f03364b733604915a7e3206753a00e43.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 91]: /images/20230528/918261d3aadf4266a646bbc96ea916f5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 92]: /images/20230528/f108fd52bcaa49f695b3f559aa8b9af0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 93]: /images/20230528/10ca176dc3fd4a59840842403548b252.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 94]: /images/20230528/b3a69d5787454a78812e957579228e69.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 95]: /images/20230528/7b5ef0540424414b83e22ef772658af3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 96]: /images/20230528/b4b14045201841b98b5edfc6322f5ba5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 97]: /images/20230528/e895b8608cbc43028b24588c40eeac61.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 98]: /images/20230528/1c22bfeb66b14f7f906560066b371b6e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 99]: /images/20230528/85cecff16f32412e88b50d5a371adb41.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 100]: /images/20230528/f726288ffd86438bbcb77c2e75fbfe06.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 101]: /images/20230528/fb8a9f02f8ab4cf2a4756ae6fe497629.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 102]: /images/20230528/9257e1b8254743128e18c03ea53d4af2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 103]: /images/20230528/4ac3f15c76f14c1998301af358bf6b88.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 104]: /images/20230528/61ca7ef1d48344f994b66e416f0d3104.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 105]: /images/20230528/36d86deb4c6045eca867baad428c67e5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 106]: /images/20230528/c8153b2b0cc54073b41062173f76c94b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 107]: /images/20230528/e2edb353e8e34c8f9720ba76c203154e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 108]: /images/20230528/04eddcceb04640dfbf621ea3e07438d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 109]: /images/20230528/40f2fb9d1ecd4fb4b3c78e0c973d5b95.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 110]: /images/20230528/6cf633220e20403389eb6d33d3ed9efa.png
[2019070618540114.png]: /images/20230528/94d80ddee20d48f7b3b0e7144ac24c6a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 111]: /images/20230528/646cf1a9dad64bfcb2d9a85d65ffeb5e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 112]: /images/20230528/4f05ae74ee594cc09492eee0d469f569.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 113]: /images/20230528/7f24a3a1cc954fa6b877be3bebd37c1e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 114]: /images/20230528/39a9360ec6ad4f508ad5fb5ef2c4ce5c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 115]: /images/20230528/9fbed0a18f794fe59f6880641e55cee2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 116]: /images/20230528/5282e30a2c8b4ac6b70a73a8f9ddb91f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 117]: /images/20230528/21e1069c3b6b4cb3bb69f0a6630550a0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 118]: /images/20230528/51d984e2b34f44b6bd6f793a37a8f26e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 119]: /images/20230528/4dc3e53e5110475e88d4acf3f4352c97.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 120]: /images/20230528/19155a31df05476f96642464b8c157b8.png
[20190706205420451.png]: /images/20230528/a7adc92fee7746d693ab37f5a390309c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1poYW5nZ3VvaGFvNjY2_size_16_color_FFFFFF_t_70 121]: /images/20230528/e335a70b86b14c4e9a5bef334f2eea7f.png
[20190707153017264.png]: /images/20230528/b977c2ad53434dcc815610d1c4743c17.png