数据库作业实验二、实验三2021011206贾天乐

贾天乐

2021011206

按照逻辑随机生成测试数据并进行查询

SELECT sname 姓名, 2020-sage 出生年份,sdept 所在系

FROM student2021011206;

SELECT DISTINCT sno

FROM sc2021011206;

SELECT sno ,sname

FROM student2021011206

WHERE sdept='计算机' and sage<20;

SELECT sno ,sname,sdept,sage

FROM student2021011206

WHERE sage not BETWEEN 20 AND 23 and ssex='女';

SELECT sno,sname,ssex

FROM student2021011206

WHERE sdept in('数学','计算机');

SELECT sno,sname

FROM student2021011206

WHERE sname like '张%' or sname like '刘%';

SELECT sno 学号,grade*0.75 成绩

FROM sc2021011206

WHERE grade BETWEEN 80 AND 90;

SELECT cno

FROM course2021011206

WHERE cpno is null and ccredit>1;

SELECT sno,grade

FROM sc2021011206

Where cno=1001

ORDER BY grade DESC,sno ASC