/****** Script for SelectTopNRows command from SSMS ******/
--1 1
SELECT TOP 1000 *FROM [MySchool].[dbo].[Student]
WHERE Address LIKE '山东%'
--2
SELECT SubjectId,SubjectName,ClassHour,GradeId FROM dbo.Subject
WHERE SubjectName LIKE '%数据库%'
order BY GradeId
--3
SELECT StudentName,Address,Phone FROM dbo.Student
WHERE Phone LIKE'1387%'
--4
SELECT StudentNo,StudentName,Address from dbo.Student
WHERE StudentName LIKE'姜_'
--5
SELECT *FROM dbo.Student WHERE StudentNo LIKE'S1101004'AND GradeId IN(1,2,3)
--6
SELECT *FROM dbo.Student WHERE BornDate BETWEEN '1989-1-1'AND '1995-12-31'
--2 1
SELECT COUNT(StudentNo) AS 学生总人数 from dbo.Student
--2
SELECT SUM(ClassHour) AS 总学时 FROM dbo.Subject WHERE GradeId=1
--3
SELECT SUM(StudentResult) AS 总成绩 from dbo.Result,Grade WHERE StudentNo='S1101004' and GradeId=1
--4
SELECT AVG(StudentResult) AS 平均分 from dbo.Result,Grade WHERE StudentNo='S1101004' and GradeId=1
--5
select MAX(StudentResult) as 最高分,MIN(StudentResult) AS 最低分 ,AVG(StudentResult) AS 平均值 from Result,Subject where ExamDate='2013-3-22' and SubjectName='使用C#语言开发数据库应用系统'
--6
select AVG(StudentResult) AS 及格平均值 from Result,Subject where ExamDate='2013-3-22' and SubjectName='使用C#语言开发数据库应用系统' and StudentResult>60