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

//使用模糊查询查询学生相关信息SELECT StudentName,Phone,Address FROM Student WHERE StudentName LIKE '%山东%'SELECT SubjectName,ClassHour,GradeId FROM Subject WHERE SubjectName LIKE'%数据库%' ORDER BY GradeIdSELECT 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 StudentSELECT SUM(ClassHour)AS 总学时 FROM Subject WHERE GradeId=1SELECT 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