数据库实验三

SELECT Sname,Sdept,Sage
 FROM Student;
 
SELECT Sname NAME,2022-Sage BIRTHDAY,Sdept DEPARTMENT
FROM Student

SELECT Cno
FROM SC;

SELECT DISTINCT Sno
FROM SC
WHERE Grade<60;

SELECT  Sno
FROM SC
WHERE Grade BETWEEN 80 AND 90;

SELECT Sno,Sname
FROM Student
WHERE Sname LIKE '_小_';

SELECT Cno,Ccredit
FROM Course
WHERE Cname LIKE 'DB\_%i__'ESCAPE'\';

SELECT Sno,Grade*0.8
FROM SC
WHERE Cno='1'AND Grade BETWEEN 80 AND 90;

select *
from student
where (sdept ='CS' or sdept ='MA') and sname like'张%'