第三本十一章上机题

SELECT TOP 1000 [StudentNo]
      ,[LoginPwd]
      ,[StudentName]
      ,[Sex]
      ,[GradeId]
      ,[Phone]
      ,[Address]
      ,[BornDate]
      ,[Email]
  FROM [MySchol].[dbo].[Student]
  SELECT GradeId AS 年纪,COUNT(*) AS 人数
  FROM dbo.Student
  GROUP BY GradeId
  SELECT Sex AS 性别,CounT(*)
  FROM dbo.Student
  GROUP BY Sex
  --查询每学期学生的平均年龄
  SELECT AVG(DATEDIFF(dd,BornDate,GETDATE())/365)  as 年龄
  from dbo.Student
  --查询北京地区的每学期学生人数
  SELECT COUNT(GradeId) as 个数,GradeId
    FROM dbo.Student
    WHERE Address LIKE '北京%'
    GROUP BY GradeId
  --查询学生姓名 年级名称 联系电话
  SELECT StudentName,StudentNo,Phone
  FROM dbo.Student
  --查询年级编号为1的年级名称 科目名称及学时
  SELECT s.StudentName,c.SubjectName,c.ClassHour
  from dbo.Student AS s
  INNER JOIN dbo.Subject AS c on(s.GradeId=c.GradeId AND s.GradeId=1)

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Id]
      ,[StudentN