SQL第十章模糊查询和聚合函数上机题1-2

//使用模糊查询查询学生相关信息
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