C#上机练习2

--上机练习2
	SELECT GradeId,COUNT(*) AS 课程数 FROM dbo.Subject  GROUP BY GradeId HAVING SUM(ClassHour)>50
	
	SELECT GradeId,AVG(DATEDIFF(dd,BornDate,GETDATE())/365) AS 平均年龄 FROM dbo.Student  GROUP BY GradeId 
	
	SELECT GradeId,COUNT(*) FROM dbo.Student WHERE Address like '北京%' GROUP BY GradeId
	
	SELECT StudentNo,AVG(StudentResult) FROM dbo.Result  GROUP BY StudentNo HAVING AVG(StudentResult)>=60 ORDER BY AVG(StudentResult) DESC
	
	SELECT SubjectId,AVG(StudentResult) FROM dbo.Result WHERE ExamDate='2013-3-22' GROUP BY SubjectId HAVING AVG(StudentResult)>=60  
	
	SELECT StudentNo,COUNT(StudentResult) FROM dbo.Result WHERE StudentResult<60 GROUP BY StudentNo