展示teaching数据库中的表结构名称;
show tables;
展示各个表结构的组成;
select * from c;
查询考试成绩有不及格的学生的学号;
select sno,grade from sc where grade < 60;
查询年龄在20~23岁之间的学生的姓名、院名;
select sname,sdept,age from s where age between 20 and 23;
查询计算机系的女生信息;
select * from s where sex = '女' and sdept = '计算机';
查询名字中第二个字为“明”字的男学生的姓名和系名;
select sname,sdept,sex from s where sex = '男' and sname like '_明%';
查询所有名字不是姓王的同学的姓名、性别和年龄;
select sname,sex,age from s where sname not like '王%';
查询选修了“180101”号课程且成绩在70~80之间的同学的学号;
select sno from sc where cno = 180101 and grade between 70 and 80;
查询课程名中带有‘_’的课程名;
SELECT cname FROM c WHERE cname LIKE '[_]' escape '_';
选修上课编号为180101且成绩在80-90 之间的学生学号和成绩,并将成绩乘以系数0.75 输出,设置标题newgrade。
select sno,0.75*grade as newgrade from sc where cno = 180101 and grade between 80 and 90;
查询学分不是64和48的课程名称。
select cname from c where credit != 64 and credit != 48;