第十章 上机 (SQL)

--上机练习1
--NO.1
SELECT StudentName,Phone,[Address] FROM Student WHERE Address LIKE '山东%'
--NO.2
SELECT SubjectName,ClassHour,GradeId FROM Subject WHERE SubjectName LIKE '%数据库%' ORDER BY GradeId
--NO.3
SELECT StudentName,Phone,[Address] FROM Student WHERE Phone LIKE '1387%'
--NO.4
SELECT StudentName,StudentNo,[Address] FROM Student WHERE StudentName LIKE '姜_'
--NO.5
SELECT Id,StudentNo,SubjectId,StudentResult,ExamDate FROM Result WHERE StudentNo LIKE 's1101004' AND SubjectId LIKE '[1-3]'
--NO.6
SELECT * FROM Student WHERE BornDate BETWEEN '1989-1-1' AND '1995-12-31'

 

--上机练习二
--NO.1.
SELECT COUNT(*)FROM Result
--NO.2.
SELECT SUM(ClassHour)FROM Subject
--NO.3
SELECT SUM(StudentResult) AS 学号为s1101004 FROM Result,Grade  WHERE StudentNo='s1101004' AND GradeId=1  
--NO.4
SELECT AVG(StudentResult) AS 学号为