高分求SQL问题答案，懂得大师请帮帮忙
发布网友
发布时间：2022-03-18 10:41
共1个回答
热心网友
时间：2022-03-18 12:10
dbacb
aaddc
cdcab
bcbac
select * from score where 成绩 in(85,86,88);
select * from score where 成绩 between 60 and 80;
select * from student where 班级= '95031' and 性别 = '女';
select avg(分数) from 成绩 where 编号= ‘3-105‘;
select sname,cno,degree from 学生表;
select distinct depart from 教师表;
select * from score order by cno,degree desc;
select * from 成绩 where 课程= '3-105' and 成绩>109 order by 成绩;
select count(0) from 学生表 where 班级号 = '95031'
