//使用模糊查询查询学生相关信息
SELECT StudentName,Phone,Address FROM Student WHERE StudentName LIKE %山东%
SELECT SubjectName,ClassHour,GradeId FROM Subject WHERE SubjectName LIKE%数据库% ORDER BY GradeId
SELECT StudentName,Phone,Address FROM Student WHERE Phone LIKE 1387%
SELECT StudentNo,StudentName,Address FROM Student WHERE StudentName LIKE 姜_
SELECT StudentResult FROM Result WHERE SubjectId IN(1,2,3) AND StudentNo=S1101004
SELECT * FROM Student WHERE BornDate BETWEEN 1989-1-1 AND 1995-12-31
//查询汇总信息
SELECT COUNT(*) AS 学生总人数 FROM Student
SELECT SUM(ClassHour)AS 总学时 FROM Subject WHERE GradeId=1
SELECT SUM(StudentResult)AS 第一期总成绩 FROM Result WHERE StudentNo=S1101004
SELECT AVG(StudentResult)AS 第一期平均分 FROM Result WHERE StudentNo=S1101004
SELECT MAX(StudentResult) AS 最高分, MIN(StudentResult) AS 最低分, AVG(StudentResult)AS 平均分 FROM Result WHERE SubjectId=8 AND ExamDate=2013-3-22
SELECT AVG(StudentResult)AS 平均分 FROM Result WHERE SubjectId=8 AND StudentResult>60 AND ExamDate=2013-3-22
SELECT AVG(StudentResult)AS 平均分 FROM Result WHERE SubjectId=1
