mysql 练习题及答案 50道

最新推荐文章于 2024-07-24 00:18:29 发布
最新推荐文章于 2024-07-24 00:18:29 发布
阅读量4.6k 收藏 67
点赞数 4
分类专栏： mysql 文章标签： mysql 面试题

此50题参考出处，题目一样，代码有出入,因为题目比较有意思，都自己做了一次。

https://zhuanlan.zhihu.com/p/50662216

 

-- 1、查询课程编号为“01”的课程比“02”的课程成绩高的所有学生的学号。
-- 方法1
select * from score a inner join score b on (a.s_id = b.s_id and a.c_id='01' and b.c_id='02' and a.s_score>b.s_score);
-- 方法2
select * from score a inner join score b where (a.s_id = b.s_id and a.c_id='01' and b.c_id='02' and a.s_score>b.s_score);
-- 方法3
select * from  (select * from score where c_id='01') as a inner join (select * from score where c_id='02') as b on a.s_id=b.s_id
where a.s_score>b.s_score;


-- 2、查询平均成绩大于60分的学生的学号和平均成绩
-- 方法1
select s_id,avg(s_score) as avgs from score group by s_id HAVING avg(s_score)>60;
-- 方法2
select a.s_id,a.avgs from (select s_id,avg(s_score) as avgs from score group by s_id) as a where a.avgs >60;


-- 3、查询所有学生的学号、姓名、选课数、总成绩
select stu.s_id,stu.s_name,count(stu.s_id),sum(sc.s_score) from student as stu inner join score as sc on sc.s_id =stu.s_id group by (s_id);


-- 4、查询姓“张”的老师的个数
select count(t_id) from teacher where t_name like "张%";

-- 5.查询没学过“张三”老师课的学生的学号、姓名(重点)sc.s_id,stu.s_name

-- 错误：
select * from score as sc inner join student stu on stu.s_id=sc.s_id 
where sc.c_id not in
(select c_id from course where t_id=
(select t_id from teacher where t_name='张三')) group by sc.s_id;

-- 正确1：
select s_id, s_name from student as c where c.s_id not in 
(select sc.s_id from score as sc inner join student stu on stu.s_id=sc.s_id where sc.c_id in
(select c_id from course where t_id=
(select t_id from teacher where t_name='张三')));

-- 正确2 推荐：
select s_id, s_name
from Student
where s_id not in 
(select s_id from Score join Course on Score.c_id = Course.c_id
join Teacher on Course.t_id = Teacher.t_id
where t_name = '张三');

-- 理解过程及注意1：
-- 在一对多的情况下，一定不能够直接not in某两个表里笛卡尔集的数据，要先找出唯一对应的，即学过张三的课的学生，再找没有学过的
-- 1、select t_id from teacher where t_name='张三' 查张三的id
-- 2、select c_id from course where t_id=(查张三的id) 查课程的id
-- 错误：3、select * from score as sc inner join student stu on stu.s_id=sc.s_id where sc.c_id not in (查课程的id) group by sc.s_id 
-- 正确3：select sc.s_id from score as sc inner join student stu on stu.s_id=sc.s_id where sc.c_id  in(查课程的id) 找出学过张三的课的学生
-- 正确4：select * from student as c where c.s_id not in (找出学过张三的课的学生)


-- 理解过程及注意2：推荐
-- 使找出学过的id，再找没学过的id
-- 1、Score 有学生id和课程id,并作为主键，可以找出唯一学过张三id的所有学生
-- select s_id from Score join Course on Score.c_id = Course.c_id
-- join Teacher on Course.t_id = Teacher.t_id
-- where t_name = '张三'
-- 2、使用not in 


-- 6、查询学过“张三”老师所教的所有课的同学的学号、姓名
-- 方法1
select * from score join course on score.c_id = course.c_id join teacher on teacher.t_id =course.t_id join student on student.s_id=score.s_id where teacher.t_name='张三';

-- 方法2
select s_id, s_name
from Student
where s_id  in 
(select s_id from Score join Course on Score.c_id = Course.c_id
join Teacher on Course.t_id = Teacher.t_id
where t_name = '张三');


-- 7、查询学过编号为“01”的课程并且也学过编号为“02”的课程的学生的学号、姓名
select student.s_id,student.s_name from (select s_id from score where score.c_id='01') as a 
join (select s_id from score where score.c_id='02') as b on a.s_id=b.s_id 
join student where student.s_id=a.s_id;


select student.s_id,student.s_name from student where s_id in (select s_id from score where score.c_id='01')
and s_id in (select s_id from score where score.c_id='02');

-- 8、查询课程编号为“02”的总成绩
select sum(s_score)
from Score
where c_id = '02';

-- 9、查询所有课程成绩小于60分的学生的学号、姓名
-- select student.s_id,student.s_name from score join student on student.s_id=score.s_id  group by (score.s_id) having max(score.s_score)<60  --这个会缺少没有成绩的学生,当然，题目也没有明确
-- 方式1
select student.s_id,student.s_name from student where student.s_id not in (select s_id from score group by (score.s_id) having max(score.s_score)>=60);

-- 方式2
select s_id, s_name
from Student 
where s_id NOT IN (SELECT s_id FROM Score where s_score >=60);


-- 10、查询没有学全所有课的学生的学号、姓名（题目没有明确要不要完全没学的学生）

select s_id, s_name
from Student 
where s_id NOT IN (SELECT s_id FROM Score group by s_id having count(*)=3); -- 含那个没成绩的学生

-- 方式1
select s_id, s_name
from Student 
where s_id  IN (SELECT s_id FROM Score group by s_id having count(*)<3);  -- 不含那个没成绩的学生

-- 方式2
SELECT student.s_id,student.s_name FROM Score join student on student.s_id=score.s_id group by score.s_id
having count(*)<3; -- 不含那个没成绩的学生


-- 11、查询至少有一门课与学号为“01”的学生所学课程相同的学生的学号和姓名
-- 方式一
select student.s_id,student.s_name from score join student on student.s_id=score.s_id  where score.c_id in 
(select c_id from score where s_id='01') and score.s_id !='01' group by score.s_id;
-- 方式2
select distinct a.s_id,a.s_name
from Student a join Score b on a.s_id= b.s_id
where c_id in
(select c_id from Score where s_id = '01')
and a.s_id<>'01';


-- 12、查询和“01”号同学所学课程完全相同的其他同学的学号


select sc.s_id,count(sc.s_id) from score as sc 
where 
sc.s_id <>'01' and  sc.c_id in (select c_id from score where s_id='01') 
group by sc.s_id 
having 
count(sc.s_id)=(select COUNT(*) from score where s_id='01') 
and 
(select COUNT(*) from score where s_id='01')=(select COUNT(*) from score where s_id=sc.s_id)


-- 以下是作者提供的答案，个人认为不正确。例如，把01换成07,没有考虑多出来的情况
select s_id
from Score
where c_id in
(select c_id from Score where s_id='01')
and s_id <> '01'
group by s_id
having count(c_id)=(select count(c_id) from Score where s_id='01');

-- 13.把“Score”表中“张三”老师教的课的成绩都更改为此课程的平均成绩（难点）

-- 方式1
update  score as a join (select Score.c_id,avg(s_score) as t from score where score.c_id=(select c_id from course where t_id=(select t_id from teacher where t_name='张三')) group by c_id) as b on a.c_id=b.c_id set a.s_score=t;

-- 方式2
UPDATE Score AS a
JOIN (
    SELECT
        AVG( s_score ) AS t,
        Score.c_id 
    FROM
        Score
        JOIN Course ON Score.c_id = Course.c_id
        JOIN Teacher ON Teacher.t_id = Course.t_id 
    WHERE
        t_name = '张三' 
    GROUP BY
        c_id 
    ) AS b ON a.c_id = b.c_id 
    SET a.s_score = b.t;

-- 14、查询和“02”号的同学学习的课程完全相同的其他同学学号和姓名(同12题）

-- 15、删除学习“张三”老师课的SC表记录

delete from Score
where c_id =(select c_id from Course join Teacher on Course.t_id=Teacher.t_id
where t_name ='张三')

-- 16.检索"01"课程分数小于60，按分数降序排列的学生信息
select * from score join student on student.s_id=score.s_id where score.s_score<60 and score.c_id='01' order by score.s_score desc

-- 17、按平均成绩从高到低显示所有学生的“数据库”（c_id='04'）、“企业管理”（c_id='01'）、“英语”（c_id='06'）三门的课程成绩，按如下形式显示：学生ID，数据库，企业管理，英语，有效课程数，有效平均分

select s_id as '学生ID',
(case when c_id='04' then s_score else NULL end) as '数据库',
(case when c_id='01' then s_score else NULL end) as '企业管理',
(case when c_id='06' then s_score else NULL end) as '英语',
count(c_id) as '有效课程数',
avg(s_score) as '有效平均分'
from Score
group by s_id
order by avg(s_score) DESC;


-- 18、查询各科成绩最高和最低的分： 以如下的形式显示：课程ID，最高分，最低分

select c_id,max(s_score),min(s_score) from score group by c_id 

-- 19、按各科平均成绩从低到高和及格率的百分数从高到低排列，以如下形式显示：课程号,课程名,平均成绩,及格百分数
select course.c_id,course.c_name,avg(sc.s_score),concat((select count(*) from score as sc1 where sc1.s_score>=60 and sc1.c_id=sc.c_id)/count(*)*100,"%")
 from score as sc join course on course.c_id=sc.c_id group by sc.c_id order by avg(sc.s_score)

-- 21、查询不同老师所教不同课程平均分从高到低显示

select course.c_id,teacher.t_name,course.c_name,avg(sc.s_score),concat((select count(*) from score as sc1 where sc1.s_score>=60 and sc1.c_id=sc.c_id)/count(*)*100,"%")
 from score as sc join course on course.c_id=sc.c_id join teacher on teacher.t_id=course.t_id group by sc.c_id order by avg(sc.s_score);


-- 23、使用分段[100-85],[85-70],[70-60],[<60]来统计各科成绩，分别统计各分数段人数：课程ID和课程名称

select sc.c_id,cu.c_name, sum(case when sc.s_score>=85 and sc.s_score <=100 then 1 else 0 end) '[100-85]',
sum(case when sc.s_score>=70 and sc.s_score <=85 then 1 else 0 end) '[85-70]',
sum(case when sc.s_score>=60 and sc.s_score <=70 then 1 else 0 end) '[70-60]',
sum(case when sc.s_score>=0 and sc.s_score <60 then 1 else 0 end) '[<60]'
from score as sc join course as cu on sc.c_id=cu.c_id group by c_id


-- 24、查询学生平均成绩及其名次
-- 作者提示要点：算出在所有同学中有几个同学的平均分高于某个ID,然后+1，就是名次
-- 方式1：推荐
select table1.s_id as '学号',avg as '平均成绩' ,@a:=@a+1 as '名次
' from (select *,avg(sc.s_score) as avg from score as sc group by sc.s_id order by avg(sc.s_score) desc) as table1,(select @a:=0) as b
-- 方式2:
SELECT s_id as '学号',平均成绩,
      (SELECT COUNT(*) FROM(SELECT s_id,AVG(s_score)AS '平均成绩'
                            FROM Score GROUP BY s_id)AS b 
       WHERE b.平均成绩>a.平均成绩)+1 as RANK
FROM (select s_id,avg(S_score) as 平均成绩 from Score group by s_id)AS a
order by 平均成绩 desc;

-- 25、查询各科成绩前三名的记录（不考虑成绩并列情况）

select sc1.c_id,sc1.s_id,sc1.s_score from score as sc1
where (select count(*) from score as sc2 where sc1.s_score < sc2.s_score and sc1.c_id=sc2.c_id)<=2
ORDER BY sc1.c_id ASC,sc1.s_score DESC;


-- 26、查询每门课程被选修的学生数

select c_id,count(*) from score group by c_id

-- 27、查询出只选修了两门课程的全部学生的学号和姓名

select score.s_id,student.s_name from score join student on student.s_id=score.s_id group by s_id HAVING count(*)=2

-- 28、查询男生、女生人数
select s_sex,count(*) from student GROUP BY s_sex

-- 29、查询名字中含有“风”字的学生信息
select * from student where s_name like '%风%'

-- 30、查询同名同姓学生名单并统计同名人数
-- 方式1:
select * from student as s1 where (select count(*) from student s2 where s2.s_name=s1.s_name and s1.s_id<>s2.s_id) 
-- 方式2:
select * from student as s1 join student as s2 on s1.s_id<>s2.s_id and s1.s_name=s2.s_name
-- 方式3:推荐
select s_name,count(*) from student GROUP BY s_name HAVING count(*)>1

-- 31、1990年出生的学生名单（注：Student表中s_birth列的类型是datetime）
select * from student where s_birth like "1990%"

select * from student where year(s_birth)=1990

-- 32、查询平均成绩大于85的所有学生的学号、姓名和平均成绩
select student.s_id,student.s_name,avg(s_score) from student join score on student.s_id=score.s_id group by (score.s_id) HAVING avg(s_score)>85

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

select c_id,avg(s_score) as avg from score group by c_id order by avg asc,c_id desc

-- 34、查询课程名称为“数学”且分数低于60的学生姓名和分数

select student.s_name,score.s_score from score join course on score.c_id=course.c_id join student on student.s_id=score.s_id where course.c_name='数学' and score.s_score<60;


-- 35、查询所有学生的选课情况

select student.s_name,course.c_name from student join score on score.s_id=student.s_id join course on course.c_id=score.c_id


-- 36、查询任何一门课程成绩在70分以上的姓名、课程名称和分数
select s_name as 姓名,c_name as 课程名称,s_score as 分数 from student join score on student.s_id=score.s_id join course on course.c_id=score.c_id where s_score>70

-- 37、查询不及格的课程并按课程号从大到小排列
select * from score where s_score<60 order by c_id

-- 38、查询课程编号为03且课程成绩在80分以上的学生的学号和姓名
-- 方式一:
select * from student join score on student.s_id=score.s_id where s_score>80 and c_id='03'
-- 方式二:
select * from student where s_id in (select s_id from score where s_score>80 and c_id='03')


-- 39、查询选了课程的学生人数
-- 方式一:推荐
select count(distinct s_id) from score
-- 方式二:
select count(*) from (select count(*) from score group by s_id) as b

-- 40、查询选修“张三”老师所授课程的学生中成绩最高的学生姓名及其成绩
-- 方式1
select s_name,max(s_score) from teacher join course on teacher.t_id = course.t_id join score on score.c_id=course.c_id join student on student.s_id=score.s_id where t_name='张三' group by (teacher.t_id)

-- 方式2
select s_name,s_score from teacher join course on teacher.t_id = course.t_id join score on score.c_id=course.c_id join student on student.s_id=score.s_id where t_name='张三' order by s_score desc limit 1

-- 41、查询各个课程及相应的选修人数
select score.c_id,course.c_name,count(*) from score join course on score.c_id=course.c_id group by c_id

-- 42、查询不同课程成绩相同的学生的学生编号、课程编号、学生成绩

select distinct sc1.s_id,sc1.c_id,sc1.s_score from score as sc1 join score as sc2 on sc1.s_id=sc2.s_id and sc1.c_id<>sc2.c_id and sc1.s_score=sc2.s_score;

-- 43、查询每门课程成绩最好的前两名 同25题
select * from score as sc1 where (select count(*) from score as sc2 where sc2.s_score>sc1.s_score and sc1.c_id=sc2.c_id)<2 order BY sc1.c_id


-- 44、统计每门课程的学生选修人数(超过5人的课程才统计)。要求输出课程号和选修人数，查询结果按人数降序排序，若人数相同，按课程号升序排序

select c_id,count(*) from score group by c_id having count(*)>5 order by count(*) desc,c_id asc

-- 查询至少选修两门课程的学生学号
select s_id,count(*) from score group by s_id having count(*)>=2

-- 46、查询选修了全部课程的学生信息

select s_id,count(*) from score group by s_id having count(*)=(select count(*) from course)

-- 47、查询没学过“张三”老师讲授的任一门课程的学生姓名

select * from student where s_id not in ( select score.s_id from teacher join course on course.t_id=teacher.t_id join score on score.c_id=course.c_id join student on student.s_id=score.s_id where teacher.t_name='张三' group by score.s_id)

-- 48、查询两门以上不及格课程的同学的学号及其平均成绩

select s_id,avg(s_score) from score where s_score<60 group by s_id

-- 49、检索课程编号为“01”且分数小于60的学生学号，结果按按分数降序排列
select s_id
from Score
where c_id='01'
and s_score <60
order by s_score DESC;

-- 50、删除学生编号为“02”的课程编号为“01”的成绩
delete from score where s_id='02' and c_id='01'
 


 

chenxf居然已经存在
关注
专栏目录
MySQL练习题 （练习表+题目+答案）
qq_42192701的博客
03-11 1万+
mysql练习题 （表+题目+答案） 一、创建所需要练习的表 CREATE TABLE J_TEACHER ( tno int NOT NULL PRIMARY KEY, tname varchar(20) NOT NULL ); INSERT INTO J_TEACHER(tno,tname)VALUES(1,‘张老师’); INSERT INTO J_TEACHER(tno,tname)VAL...
MySQL经典练习题及答案，常用SQL语句练习50题
热门推荐
qq_41936662的博客
05-21 9万+
表名和字段–1.学生表 Student(s_id,s_name,s_birth,s_sex) –学生编号,学生姓名, 出生年月,学生性别 –2.课程表 Course(c_id,c_name,t_id) – –课程编号, 课程名称, 教师编号 –3.教师表 Teacher(t_id,t_name) –教师编号,教师姓名 –4.成绩表 Score(s_id,c_id,s_score) –学生编号,课程...
【SQL】超全！以练代学，练完这篇，搞定MySQL语句！（基础篇）
最新发布
Liu_y_xin的博客
07-24 1098
以练代学，练完这篇，搞定MySQL语句！（基础篇）包括了增删改查等必须掌握的SQL操作
# MySQL练习 50道，题目+ 答案
Kayleigh520的博客
01-13 642
mysql的练习题
sql语句练习50题(Mysql版)
Coder-Wf
09-10 3985
表名和字段 –1.学生表 Student(s_id,s_name,s_birth,s_sex) –学生编号,学生姓名, 出生年月,学生性别 –2.课程表 Course(c_id,c_name,t_id) – –课程编号, 课程名称, 教师编号 –3.教师表 Teacher(t_id,t_name) –教师编号,教师姓名 –4.成绩表 Score(s_id,c_id,s_scor...
MySQL数据库考试试题及答案
11-01
MySQL数据库考试试题及答案，详情摘要请参见博客内容，谢谢
MySQL练习题及答案-11页
06-01
MySQL是一种广泛使用的开源关系型数据库管理系统，其特点包括高效、可靠和可扩展性。...通过这些练习题，我们可以深入理解MySQL的各个核心概念，提升在数据库管理、查询优化和故障排查方面的能力。
MySQL SQL语句练习题及答案
12-21
MySQL SQL语句练习题及答案 本资源提供了 MySQL SQL 语句的练习题及答案，涵盖了创建表、插入数据、删除数据、更新数据、查询数据等多方面的知识点。 一、创建表 在 MySQL 中，创建表使用 CREATE TABLE 语句。...
MySQL数据库操作练习题及答案（以员工信息数据库为例）经典.rar
05-30
这份"MySQL数据库操作练习题及答案（以员工信息数据库为例）经典.rar"资料，旨在帮助学习者深入理解和掌握MySQL的各种核心功能，包括数据的过滤、连接、分组、聚合、子查询、字符串处理、表操作以及触发器的使用。...
50道MySQL经典练习题
12-14
这个是网上流传的50道SQL练习题，最近拿来练习，刚做完，这里把我做的答案给大家做个参考，如有错误，还请告知。 另外，做题的时候先不要看答案（答案不唯一，只要满足要求即可），要有自己的一个思考过程，这样做...
mysql数据库练习题_50道SQL练习题及答案（MySQL版）
weixin_29345939的博客
02-28 2302
网上流传的50道sql练习，发现其答案部分有问题，故在此记录下个人用mysql 的实现。数据表介绍--1.学生表Student(SId,Sname,Sage,Ssex)--SId 学生编号,Sname 学生姓名,Sage 出生年月,Ssex 学生性别--2.课程表Course(CId,Cname,TId)--CId 课程编号,Cname 课程名称,TId 教师编号--3.教师表Teacher(TI...
mysql练习题
05-16
mysql练习题，一些简单的mysal练习题，适合初学者哦
MySQL基础练习题及答案
03-11
针对于MySQL刚入门和有一定基础的学员，适合多次练习。
经典SQL练习题(MySQL版)
weixin_33834137的博客
09-08 2万+
原文首发于简书于[2018.07.30] 网上有一篇关于SQL的经典文章，超经典SQL练习题，做完这些你的SQL就过关了，引用和分析它的人很多，于是今天复习SQL的时候找来练了练手。原作者用的是SQL Server 2008，我在这里用的是MySQL 8.0.11（二者语法差别不大），文本编辑器用的是Atom 1.28.2（不知道大家用什么，反正用At...
mysql练习
如故的博客
06-29 582
MySql 实践 基本命令 1, 查询当前访问数据库的用户信息 select user(); show processlist; 2, 查询数据库服务器中的数据库列表 show databases; 3, 使用数据库 scott use scott; 4, 查询当前数据库的名称 select database(); 5, 查询 scott 数据库的创建语句 ...
MySQL入门（下）
apple3515的博客
11-09 128
1. 课程回顾(很清晰明了) mysql基础 1）mysql存储结构： 数据库 -> 表 -> 数据 sql语句 2）管理数据库： 增加： create database 数据库 default character utf8; 删除： drop database 数据库; 修改： alter database 数据库 default character...
mysql 练习
on_the_way_to_travel的专栏
05-13 1110
最近找到一个不错的 mysql sql语句练习英文网站，分享下。有兴趣的同学可以查看原文 原资源地址 原网站支持在线脚本练习，推荐网速不错的同学直接使用在线资源。 接下来我会选取其中不错的练习题，并记录下来。接下类开始mysql 语句练习，首先准备好练习环境。mysql及对应的表结构数据。 数据模型 sql脚本文件下载地址hr sql文件 点我前往下载 select 查询练习点我传送selec
Mysql练习
chenkefo的博客
08-14 720
1. 需求： 1.这里写代码片设计数据库表存储：（用户考试信息） 2. 用户信息、考试时间、考试科目与考试成绩，及所属年级！ 2. 测试数据： 1.U001, 张三，1985-09-09, 广州天河, java,80,基础班, 考试时间为2014-01-01 jsp,90,就业班, 考试时间为2014-03-01 mysql,9...
MySQL数据库题库练习题100道及答案解析
05-23
很抱歉，我无法提供完整的MySQL数据库题库练习题及答案解析。但是，我可以给您提供一些常见的MySQL面试题，希望能对您有所帮助。 1. 什么是MySQL？它的特点是什么？ 答：MySQL是一种开源的关系型数据库管理系统，它拥有以下特点： - 开源、免费 - 跨平台性 - 高性能 - 可扩展性 - 可定制性 - 安全性 2. 如何在MySQL中创建表？ 答：可以使用以下语句来创建表： ``` CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY (one or more columns) ); ``` 3. 如何在MySQL中插入数据？ 答：可以使用以下语句来插入数据： ``` INSERT INTO table_name (column1, column2, column3, ..., columnN) VALUES (value1, value2, value3, ..., valueN); ``` 4. 如何在MySQL中更新数据？ 答：可以使用以下语句来更新数据： ``` UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; ``` 5. 如何在MySQL中删除数据？ 答：可以使用以下语句来删除数据： ``` DELETE FROM table_name WHERE condition; ``` 6. 如何在MySQL中查询数据？ 答：可以使用以下语句来查询数据： ``` SELECT column1, column2, ... FROM table_name WHERE condition ORDER BY column_name ASC|DESC LIMIT count OFFSET offset; ``` 7. 如何在MySQL中连接多个表？ 答：可以使用以下语句来连接多个表： ``` SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column; ``` 8. 如何在MySQL中创建索引？ 答：可以使用以下语句来创建索引： ``` CREATE INDEX index_name ON table_name (column1, column2, ...); ``` 以上是一些常见的MySQL面试题，希望能对您有所帮助。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值