Mysql练习2

淡淡的烟草味﹌ 2024-04-17 05:40 68阅读 0赞

CREATE TABLE `Student`(
    	`s_id` VARCHAR(20),
    	`s_name` VARCHAR(20) NOT NULL DEFAULT '',
    	`s_birth` VARCHAR(20) NOT NULL DEFAULT '',
    	`s_sex` VARCHAR(10) NOT NULL DEFAULT '',
    	PRIMARY KEY(`s_id`)
    );
    
    CREATE TABLE `Course`(
    	`c_id`  VARCHAR(20),
    	`c_name` VARCHAR(20) NOT NULL DEFAULT '',
    	`t_id` VARCHAR(20) NOT NULL,
    	PRIMARY KEY(`c_id`)
    );
     
     CREATE TABLE `Teacher`(
    	`t_id` VARCHAR(20),
    	`t_name` VARCHAR(20) NOT NULL DEFAULT '',
    	PRIMARY KEY(`t_id`)
    );
    
    CREATE TABLE `Score`(
    	`s_id` VARCHAR(20),
    	`c_id`  VARCHAR(20),
    	`s_score` INT(3),
    	PRIMARY KEY(`s_id`,`c_id`)
    );
    
    insert into Student values('01' , '赵雷' , '1990-01-01' , '男');
    insert into Student values('02' , '钱电' , '1990-12-21' , '男');
    insert into Student values('03' , '孙风' , '1990-05-20' , '男');
    insert into Student values('04' , '李云' , '1990-08-06' , '男');
    insert into Student values('05' , '周梅' , '1991-12-01' , '女');
    insert into Student values('06' , '吴兰' , '1992-03-01' , '女');
    insert into Student values('07' , '郑竹' , '1989-07-01' , '女');
    insert into Student values('08' , '王菊' , '1990-01-20' , '女');
    
    insert into Course values('01' , '语文' , '02');
    insert into Course values('02' , '数学' , '01');
    insert into Course values('03' , '英语' , '03');
    
    insert into Teacher values('01' , '张三');
    insert into Teacher values('02' , '李四');
    insert into Teacher values('03' , '王五');
    
    insert into Score values('01' , '01' , 80);
    insert into Score values('01' , '02' , 90);
    insert into Score values('01' , '03' , 99);
    insert into Score values('02' , '01' , 70);
    insert into Score values('02' , '02' , 60);
    insert into Score values('02' , '03' , 80);
    insert into Score values('03' , '01' , 80);
    insert into Score values('03' , '02' , 80);
    insert into Score values('03' , '03' , 80);
    insert into Score values('04' , '01' , 50);
    insert into Score values('04' , '02' , 30);
    insert into Score values('04' , '03' , 20);
    insert into Score values('05' , '01' , 76);
    insert into Score values('05' , '02' , 87);
    insert into Score values('06' , '01' , 31);
    insert into Score values('06' , '03' , 34);
    insert into Score values('07' , '02' , 89);
    insert into Score values('07' , '03' , 98);

1) 查询“01”课程比“02”课程成绩高的学生信息和课程分数

select a.*, b.s_score AS 01_score, c.s_score AS 02_score
    from student a
    left join score b on a.s_id = b.s_id and b.c_id = '01'
    left join score c on a.s_id = c.s_id and c.c_id = '02'
    where b.s_score > c.s_score

![20190825144507516.png][]

2）查询"01"课程比"02"课程成绩低的学生的信息及课程分数

![20190825144743712.png][]

3）查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩

select s.s_id,s.s_name, ROUND(AVG(e.s_score),2) AS avg_score
    from student s left join score e
    on s.s_id = e.s_id
    GROUP BY s.s_id,s.s_name HAVING avg_score >= 60

![20190825152801489.png][]

4）查询平均成绩小于60分的同学的学生编号和学生姓名和平均成绩

(包括有成绩的和无成绩的)

(
    select s.s_id,s.s_name, ROUND(AVG(e.s_score),2) AS avg_score
    from student s left join score e
    on s.s_id = e.s_id
    GROUP BY s.s_id,s.s_name HAVING avg_score < 60
    )
    union
    (
    select a.s_id,a.s_name,0 as avg_score 
    from student a 
    where a.s_id not in (select distinct s_id from score)
    )

![20190826074319739.png][]

5）查询学生平均成绩并且按照降序排列

(
    select t.s_id,t.s_name,ROUND(AVG(s.s_score),2) as 平均成绩 from 
    score s left join student t on s.s_id = t.s_id GROUP BY t.s_id,t.s_name 
    )
    union
    (
    select a.s_id,a.s_name,0 as 平均成绩
    from student a 
    where a.s_id not in (select distinct s_id from score)
    )
    ORDER BY 平均成绩 DESC

![20190904120336661.png][]

6）查询学生平均成绩及其名次

select a.s_id, @i:= @i+1 as 排名, @avg_score:= avg_s as 平均分   
    from 
    (select s_id,ROUND(AVG(s_score),2) as avg_s from score GROUP BY s_id ORDER BY avg_s DESC) a,
    (select @i:=0, @avg_score:=0) b

![20190904122136877.png][]

7）查询所有同学的学生编号、学生姓名、选课总数、所有课程的总成绩

select s.s_id,s.s_name,COUNT(e.c_id) AS sum_course,SUM(e.s_score) AS sum_score
    from student s left join score e
    on s.s_id = e.s_id 
    GROUP BY  s.s_id,s.s_name

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzMTM0MjA4NDc3Ng_size_16_color_FFFFFF_t_70][]

8）查询"李"姓老师的数量

select COUNT(t_id) as '数量' from teacher where t_name like '李%'

![20190825160413584.png][]

9）查询学过"张三"老师授课的同学的信息

select * from student c 
    where c.s_id in (
       select s.s_id from student s left join score e on s.s_id = e.s_id where e.c_id in
    	 ( 
          select o.c_id from course o left join teacher t on o.t_id = t.t_id where t_name = '张三'
    	  )
     )

![20190825162243665.png][]

10）查询没学过"张三"老师授课的同学的信息

select * from student c 
    where c.s_id not in (
       select c.s_id from student c left join score e on c.s_id = e.s_id where e.c_id in
    	 ( 
          select o.c_id from course o left join teacher t on o.t_id = t.t_id where t_name = '张三'
    	  )
     )

![2019082516345992.png][]

11）查询没学过"张三"老师讲课的学生姓名

select c.s_name from student c 
    where c.s_id not in (
       select c.s_id from student c left join score e on c.s_id = e.s_id where e.c_id in
    	 ( 
          select o.c_id from course o left join teacher t on o.t_id = t.t_id where t_name = '张三'
    	  )
     )

![2019082519215542.png][]

12）查询学过编号为"01"并且也学过编号为"02"的课程的同学的信息

select s.* from student s, score c, score o
    where s.s_id = c.s_id and s.s_id = o.s_id and c.c_id = '01' and o.c_id = '02'

![20190825170349616.png][]

13）查询学过编号为"01"但是没有学过编号为"02"的课程的同学的信息

select s.* from student s 
    where s.s_id in (select s_id from score where c_id = '01')
    and s.s_id not in (select s_id from score where c_id = '02')

![20190825181004893.png][]

14）查询没有学全所有课程的同学的信息

select s.* from student s 
    left join score c on s.s_id = c.s_id 
    GROUP BY s.s_id HAVING COUNT(c.c_id) < (select COUNT(*) from course)

![20190825182133808.png][]

15）查询至少有一门课与学号为"01"的同学所学相同的同学的信息

select * from  student where s_id in (
        select DISTINCT s.s_id from score s where s.c_id in
    		(select s.c_id from score s where s.s_id='01')
    )

![20190825183322279.png][]

16）查询和"01"号的同学学习的课程完全相同的其他同学的信息

select s.* from student s 
    where s_id in 
    (
       select s_id from score GROUP BY s_id HAVING COUNT(c_id) = 
    	 (
    	     #下面的语句是找到'01'同学学习的课程数
    	   select COUNT(c_id) from score where s_id = '01'
    	 )
    )  
     #下面的语句是找到‘01’同学没学过的课程，有哪些同学。并排除他们
    and s_id not in 
    (
     		select s_id from score where c_id in 
    	(
    	   #下面的语句是找到‘01’同学没学过的课程
    	    select DISTINCT c_id from score where c_id not in
    			(
    			  #下面的语句是找出‘01’同学学习的课程
    				select c_id from score where s_id = '01'
    			)
    	)	GROUP BY s_id
    )
    #下面的条件是排除01同学
    and s_id not in ('01')

![201908251910278.png][]

17）查询两门及其以上不及格课程的同学的学号，姓名及其平均成绩

select s.s_id,s.s_name,ROUND(AVG(c.s_score),2) as '平均成绩' from student s 
    left join score c on s.s_id = c.s_id
    where s.s_id in 
    (
       select s_id from score where s_score < 60 GROUP BY s_id HAVING COUNT(c_id) >=2 
    ) 
    GROUP BY s.s_id,s.s_name

![20190825193339370.png][]

18）查询"01"课程分数小于60，按分数降序排列的学生信息

select s.*,c.c_id,c.s_score from student s,score c
    where s.s_id = c.s_id and c.c_id = '01' and c.s_score < 60 ORDER BY c.s_score DESC

![20190825210609392.png][]

19）按平均成绩从高到低显示所有学生的所有课程的成绩以及平均成绩

select 
    s.s_name,
    a.s_id,
    MAX(CASE WHEN a.c_id='01' THEN a.s_score END) 语文,
    MAX(CASE WHEN a.c_id='02' THEN a.s_score END) 数学,
    MAX(CASE WHEN a.c_id='03' THEN a.s_score END) 英语,
    ROUND(AVG(a.s_score),1) as 平均分数
    from score a left join student s on a.s_id = s.s_id 
    GROUP BY a.s_id ORDER BY 平均分数 DESC

![20190825215230450.png][]

20）查询各科成绩最高分、最低分和平均分：

以如下形式显示：课程ID，课程name，最高分，最低分，平均分，及格率，中等率，优良率，优秀率

及格为>=60，中等为：70-80，优良为：80-90，优秀为：>=90

select 
    o.c_id, c.c_name, 
    MAX(s_score) as 最高分, MIN(s_score) as 最低分,
    ROUND(AVG(s_score),1) as 平均分,
    ROUND(100*(SUM(case when o.s_score>=60 then 1 else 0 end)/SUM(case when o.s_score then 1 else 0 end)),2) as 及格率,
    ROUND(100*(SUM(case when o.s_score>=70 and o.s_score<=80 then 1 else 0 end)/SUM(case when o.s_score then 1 else 0 end)),2) as 中等率,
    ROUND(100*(SUM(case when o.s_score>=80 and o.s_score<=90 then 1 else 0 end)/SUM(case when o.s_score then 1 else 0 end)),2) as 优良率,
    ROUND(100*(SUM(case when o.s_score>=90 then 1 else 0 end)/SUM(case when o.s_score then 1 else 0 end)),2) as 优秀率
    from score o left join course c on o.c_id = c.c_id GROUP BY o.c_id,c.c_name

![20190825221312333.png][]

21）按各科成绩进行排序，并显示排名

(
     select * from 
       (select 
          t1.c_id,
          t1.s_score,
          (select count(distinct t2.s_score) from score t2 where t2.s_score>=t1.s_score and t2.c_id='01') 排名
        FROM score t1 where t1.c_id='01' order by t1.s_score desc) 
    s
    )
    union
    (
     select * from 
       (select 
          t1.c_id,
          t1.s_score,
          (select count(distinct t2.s_score) from score t2 where t2.s_score>=t1.s_score and t2.c_id='02') 排名
        FROM score t1 where t1.c_id='02' order by t1.s_score desc) 
    s
    )
    union
    (
     select * from 
       (select 
          t1.c_id,
          t1.s_score,
          (select count(distinct t2.s_score) from score t2 where t2.s_score>=t1.s_score and t2.c_id='03') 排名
        FROM score t1 where t1.c_id='03' order by t1.s_score desc) 
    s
    )

![2019082607404047.png][]

22）查询学生的总成绩并进行排名

select s.s_id,s.s_name,SUM(o.s_score) as 总成绩
    from student s left join score o on s.s_id = o.s_id 
    GROUP BY s.s_id,s.s_name ORDER BY 总成绩 DESC

![2019082607532515.png][]

23）查询不同老师所教不同课程平均分从高到低显示

select c.c_id,t.t_name,c.c_name,ROUND(AVG(s_score),2) as 平均成绩 from
    course c left join score s on c.c_id = s.c_id
    left join teacher t on c.t_id = t.t_id
    GROUP BY c.c_id,t.t_name,c.c_name ORDER BY 平均成绩 DESC

![20190902112215423.png][]

24）查询所有课程的成绩第2名到第3名的学生信息及该课程成绩

select c.c_id,c.s_score,c.排名,t.* from 
    (
      select s.*,@i:=@i+1 as 排名 from score s,(select @i:=0) d
    	where s.c_id='01' ORDER BY s.s_score DESC
    ) c
    left join student t on c.s_id = t.s_id
    where 排名 BETWEEN 2 AND 3 
    UNION
    select c.c_id,c.s_score,c.排名,t.* from 
    (
      select s.*,@j:=@j+1 as 排名 from score s,(select @j:=0) d
    	where s.c_id='02' ORDER BY s.s_score DESC
    ) c
    left join student t on c.s_id = t.s_id
    where 排名 BETWEEN 2 AND 3 
    UNION
    select c.c_id,c.s_score,c.排名,t.* from 
    (
      select s.*,@k:=@k+1 as 排名 from score s,(select @k:=0) d
    	where s.c_id='03' ORDER BY s.s_score DESC
    ) c
    left join student t on c.s_id = t.s_id
    where 排名 BETWEEN 2 AND 3

![20190902122750690.png][]

25）统计各科成绩各分数段人数：课程编号,课程名称,\[100-85\],\[85-70\],\[70-60\],\[0-60\]及所占百分比

select DISTINCT c.c_id, c.c_name, b.`85-100`, b.百分比, e.`70-85`, e.百分比, f.`60-70`, f.百分比, g.`0-60`, g.百分比
    from score s 
    left join (
                select c_id,SUM(CASE WHEN s_score > 85 and s_score <= 100 THEN 1 ELSE 0 END) as `85-100`,
    	               ROUND(100*(SUM(CASE WHEN s_score > 85 and s_score <= 100 THEN 1 ELSE 0 END)/COUNT(*)),2) as 百分比
               from score GROUP BY c_id) b on s.c_id = b.c_id
    left join (
                select c_id,SUM(CASE WHEN s_score > 70 and s_score <= 85 THEN 1 ELSE 0 END) as `70-85`,
    		           ROUND(100*(SUM(CASE WHEN s_score > 70 and s_score <= 85 THEN 1 ELSE 0 END)/COUNT(*)),2) as 百分比
               from score GROUP BY c_id) e on s.c_id = e.c_id
    left join (
                select c_id,SUM(CASE WHEN s_score > 60 and s_score <= 70 THEN 1 ELSE 0 END) as `60-70`,
    			       ROUND(100*(SUM(CASE WHEN s_score > 60 and s_score <= 70 THEN 1 ELSE 0 END)/COUNT(*)),2) as 百分比
               from score GROUP BY c_id) f on s.c_id = f.c_id	
    left join (
                select c_id,SUM(CASE WHEN s_score > 0 and s_score <= 60 THEN 1 ELSE 0 END) as `0-60`,
    		           ROUND(100*(SUM(CASE WHEN s_score > 0 and s_score <= 60 THEN 1 ELSE 0 END)/COUNT(*)),2) as 百分比
               from score GROUP BY c_id) g on s.c_id = g.c_id					 
    left join course c on s.c_id = c.c_id

![20190904105610704.png][]

26）查询各科成绩前三名的学生记录

-- 1.选出b表比a表成绩大的所有组

-- 2.选出比当前id成绩大的 小于三个的

select a.s_id,s.s_name,c.c_name,a.s_score
    from score a 
    left join score b on a.c_id = b.c_id and a.s_score<b.s_score
    left join course c on a.c_id = c.c_id
    left join student s on a.s_id = s.s_id
    group by a.s_id,s.s_name,c.c_name,a.s_score HAVING COUNT(b.s_id)<3
    ORDER BY a.c_id,a.s_score DESC

![20190904124547512.png][]

27）查询每门课程被选修的学生数（超过5人的课程才统计）

要求输出课程号和选修人数，查询结果按人数降序排列，若人数相同，按课程号升序排列

select b.c_id,b.c_name,COUNT(s_id) as 学生总数
    from score a
    left join course b on a.c_id = b.c_id
    GROUP BY b.c_id,b.c_name
    HAVING  学生总数 > 5  ORDER BY 学生总数 DESC, b.c_id ASC

![20190904184708656.png][]

28) 查询出只有两门课程的全部学生的学号和姓名

select s_id,s_name from student where s_id 
       in
    (
      select s_id from score GROUP BY s_id HAVING COUNT(c_id)=2
    )

![20190904130322240.png][]

29）查询男生、女生人数

select s_sex,COUNT(s_sex) as 人数 from student GROUP BY s_sex

![20190904130716997.png][]

30）查询名字中含有"风"字的学生信息

select * from student where s_name LIKE '%风%'

![20190904131009950.png][]

31）查询1990年出生的学生名单

select s_name from student where s_birth LIKE '1990%'

![20190904131516122.png][]

32）查询同名同性学生名单，并统计同名人数

select a.s_name, a.s_sex, count(*) 
    from student a  
    JOIN student b on a.s_id !=b.s_id and a.s_name = b.s_name and a.s_sex = b.s_sex
    GROUP BY a.s_name,a.s_sex

![20190904133022300.png][]

33）查询每门课程的平均成绩，结果按平均成绩降序排列，平均成绩相同时，按课程编号升序排列

select c.c_id, c.c_name, ROUND(AVG(s_score),2) as 平均成绩
    from score s left join course c on s.c_id = c.c_id
    GROUP BY c.c_id, c.c_name
    ORDER BY 平均成绩 DESC, c.c_id ASC

![20190904171713518.png][]

34）查询平均成绩大于等于85的所有学生的学号、姓名和平均成绩

select s.s_id, s.s_name, ROUND(AVG(s_score),2) as 平均成绩  
    from student s left join score c on s.s_id= c.s_id
    GROUP BY s.s_id, s.s_name 
    HAVING 平均成绩 >= 85

![20190904172215660.png][]

35）查询课程名称为"数学"，且分数低于60的学生姓名和分数

select s.s_name, e.s_score
    from student s left join score e on s.s_id = e.s_id
    where e.c_id = (
         select c_id from course where c_name = '数学'
         ) and e.s_score < 60

![20190904173937457.png][]

36）查询所有学生的课程及分数情况

select a.s_id, a.s_name,
           SUM(CASE WHEN c.c_name='语文' THEN b.s_score ELSE 0 END) as 语文,
           SUM(CASE WHEN c.c_name='数学' THEN b.s_score ELSE 0 END) as 数学,
           SUM(CASE WHEN c.c_name='英语' THEN b.s_score ELSE 0 END) as 英语,
           SUM(b.s_score) as 总分
    from student a 
    left join score b on a.s_id = b.s_id
    left join course c on b.c_id = c.c_id 
    GROUP BY a.s_id, a.s_name

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzMTM0MjA4NDc3Ng_size_16_color_FFFFFF_t_70 1][]

37）查询任何一门课程成绩在85分以上的姓名、课程名称和分数

select c.s_name,a.c_name,b.s_score
    from  course a
    left join score b on a.c_id = b.c_id
    left join student c on b.s_id = c.s_id
    where b.s_score > 85

![20190904181757955.png][]

38）查询不及格的课程信息，并且按照成绩降序排列

select c.s_id, c.s_name, a.c_name, b.s_score
    from  course a
    left join score b on a.c_id = b.c_id
    left join student c on b.s_id = c.s_id
    where b.s_score < 60
    ORDER BY b.s_score DESC

![20190904182606669.png][]

39）查询课程编号为02且课程成绩在80分以上的学生的学号和姓名和成绩

select a.s_id,b.s_name,a.s_score
    from score a left join student b on a.s_id = b.s_id
    where a.c_id = '02' and a.s_score > 80

![20190904183619479.png][]

40）查询选修"张三"老师所授课程的学生中，成绩最高的学生信息及其成绩

#查询老师id
    select c_id from course a, teacher b where a.t_id = b.t_id and b.t_name='张三'
    #查询最高分
    select MAX(s_score) from score where c_id = '02'
    #查询信息
    select a.*, b.s_score,c.c_id,c.c_name
    from student a 
    left join score b on a.s_id = b.s_id   
    left join course c on b.c_id = c.c_id  
    where b.c_id = (select c_id from course a, teacher b where a.t_id = b.t_id and b.t_name='张三')  
          and b.s_score in (select MAX(s_score) from score where c_id = '02')

![20190904190939313.png][]

41）查询不同课程成绩相同的学生的学生编号、课程编号、学生成绩

select DISTINCT b.s_id,b.c_id,b.s_score
    from score a, score b 
    where a.c_id != b.c_id and a.s_score = b.s_score

![20190904191732920.png][]

42）查询每门课程成绩最好的前两名

select a.s_id,a.c_id,a.s_score from score a 
    where (
           select COUNT(1) from score b where b.c_id = a.c_id and b.s_score >= a.s_score
          ) <= 2 ORDER BY c_id

![20190904192712920.png][]

43）检索至少选修两门课程的学生学号

select a.s_id, b.s_name, COUNT(*) as 课程总数
    from score a left join student b on a.s_id = b.s_id 
    GROUP BY a.s_id, b.s_name HAVING 课程总数 >= 2

![20190904194355450.png][]

44）查询选修了全部课程的学生信息

select * from student where s_id in
    (
      select s_id from score GROUP BY s_id HAVING COUNT(*) = 
    	(select COUNT(*) from course)
    )

![20190910191922650.png][]

45）查询各学生的年龄

-- 按照出生日期来算，当前月日 < 出生年月的月日则，年龄减一

select 
    s_name, s_birth,
    (
       DATE_FORMAT(NOW(),'%Y')
    	        -
       DATE_FORMAT(s_birth,'%Y')
                -
      (CASE WHEN DATE_FORMAT(NOW(),'%m%d') > DATE_FORMAT(s_birth,'%m%d') THEN 0 ELSE 1 END) 
    ) as age
    from student

![20190910193639740.png][]

46）查询本周过生日的学生

select * from student where WEEK (DATE_FORMAT(NOW(),'%Y%m%d')) = WEEK(s_birth)
    
    
    select * from student where YEARWEEK(s_birth)=YEARWEEK(DATE_FORMAT(NOW(),'%Y%m%d'))
    	
    select WEEK(DATE_FORMAT(NOW(),'%Y%m%d'))

![20190910195212290.png][]

47）查询下周过生日的学生

select * from student where WEEK(DATE_FORMAT(NOW(),'%Y%m%d')) + 1 = WEEK(s_birth)

![20190910195835538.png][]

48）查询本月过生日的学生

select * from student where MONTH(DATE_FORMAT(NOW(),'%Y%m%d')) = MONTH(s_birth)

![20190910200212805.png][]

49）查询下月过生日的学生

select * from student where MONTH(DATE_FORMAT(NOW(),'%Y%m%d')) + 1 = MONTH(s_birth)

![20190910200312520.png][]

[20190825144507516.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/a0e01bc33014447ab7a03325ca82da42.png
[20190825144743712.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/94b75b21728c4fb7a0f45688c4104192.png
[20190825152801489.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/c45aaf396fce423791006029b737a544.png
[20190826074319739.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/fbf30ef922954c10ba01e1dc1d370f9f.png
[20190904120336661.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/9c9f3b128b3344d9a5ddd4b4d18d748a.png
[20190904122136877.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/443a1997ad614c3a999847c197c15912.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzMTM0MjA4NDc3Ng_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/75ab3b45c1b9457ea98f0b0a5c1ce196.png
[20190825160413584.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/abfcd3c6459d4453aa57491250700e91.png
[20190825162243665.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/cff707354d784f64a39f7300d3d5ab64.png
[2019082516345992.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/3ed6b79efd4443c3a86a2e6f635d555a.png
[2019082519215542.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/a2d5751a85a0435abba7766febecf5a6.png
[20190825170349616.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/f312cab1e1e44e09af8c28767d0c3d1d.png
[20190825181004893.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/e94ddd684d3d440b8c6174b5216117be.png
[20190825182133808.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/1565df079bc54e07afe81ff35f0dbbf3.png
[20190825183322279.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/c1cef8c162854c1a99c2a64ffd64bc5a.png
[201908251910278.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/1fecdd7804d64bd2a80cda7ba181bfbe.png
[20190825193339370.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/6e1b833dec7448c08555083fb2da2406.png
[20190825210609392.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/0577112c076849d38fc8957bee37d360.png
[20190825215230450.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/7b0fa1a4a0d2475fb3f6163b40a44a09.png
[20190825221312333.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/5ceb290cf2694199ad97b338100471c8.png
[2019082607404047.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/4e2825b371de4bb5aee83c5531322031.png
[2019082607532515.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/2479af2693a14b9caef4d6704c01557c.png
[20190902112215423.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/294626011ca440288e1db8c3488d8376.png
[20190902122750690.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/774ddb1b04ce4dcbbcaede8ad8cd3f58.png
[20190904105610704.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/139da39f41a143bdbc6575ecb59be1bf.png
[20190904124547512.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/e74064549fab4881a7f67678ec7461d8.png
[20190904184708656.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/049e2f061ed64a439cd8815f259e0944.png
[20190904130322240.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/cdc65044fbb64046bd29fcf6504083e4.png
[20190904130716997.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/0f55816257df42b285895f253ea184a7.png
[20190904131009950.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/83ab104152134040ab02960ff118c64b.png
[20190904131516122.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/96e1ec8a070d405b804bb799cfa1d99f.png
[20190904133022300.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/2420d6fbee974390a9f1f058929d0c84.png
[20190904171713518.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/18e2d6a2ea8645d5972b37d2b5eaf72a.png
[20190904172215660.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/eaad91a980704256828185850809c7fe.png
[20190904173937457.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/75c8dc01fec9480393e1f8e7cfedb600.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzMTM0MjA4NDc3Ng_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/7ccb5517e7384814a3bb76e92217a667.png
[20190904181757955.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/85edce01d6504432ba9d27c44b4a90e2.png
[20190904182606669.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/299d58c612d64eef9f86d23a5d5c14ba.png
[20190904183619479.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/7325731d5a3d46429b70d55119d59d7f.png
[20190904190939313.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/c5223d2e72254b52867e748a22151b50.png
[20190904191732920.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/48732dba78704777a9688309d6e06e99.png
[20190904192712920.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/26d3d4249f9743749403dcd3346f817c.png
[20190904194355450.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/d0804b6eb7ef47d38b0dd272c0822d9d.png
[20190910191922650.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/d97999f8580a4175a464072ae981ba3d.png
[20190910193639740.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/b6f8b2883d554b10a617cd86f5cad34f.png
[20190910195212290.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/3b6bae6c8b794a579a31b94dd477e7b0.png
[20190910195835538.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/b9dfeaaf543441ac99760e9783925f3d.png
[20190910200212805.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/cbf5fc262fa14201a3d71a9cdaa095f1.png
[20190910200312520.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/4f64c112c56a4cc39191c233e77a9bd4.png