随堂练习单表查询习题

SELECT Cno, Cname, Chours FROM Courses WHRER Pre_Cno IS NULL;

SELECT DISTINCT Racademicyear AS '选课学年',
                Cno AS '课程号'
FROM Reports
ORDER BY Racademicyear;

SELECT Sno, Cno, Grade
FROM Reports
WHERE Cno='112p0046' AND Grade BETWEEN 70 AND 80;

SELECT * FROM Students WHERE Mno NOT IN ('0300', '1602');

4-5

SELECT Sno, Sname, Mno, Snative
FROM Students
WHERE Dno='03' AND Snative LIKE '山东%';

USE jxdb59;
SELECT Sno, Sname, Sgender, Sclass
FROM Students59
WHERE Sname LIKE '%王%';