qq_36074096的博客

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication1{ class Program {

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication1{ class Program {

-- 六 查询数据SELECT QQID,NickName,Age FROM BaseInfo WHERE QQID='88662753'SELECT * FROM QQUser WHERE Online=0SELECT * FROM BaseInfo a,QQUser b WHERE(a. Age >=18 AND Age <=45 ) AND a.Province='北京市'

USE MySchool--查询所有科目的参考信息（某些科目可能还没有被考试过）SELECT J.SubjectName AS 科目名称,R.StudentNo AS 学号,R.StudentResult AS 分数FROM Subject AS JLEFT OUTER JOIN Result AS RON J.SubjectId=R.SubjectIdSELECT

--上机练习一--NO.1SELECT Gradeid AS 学期,COUNT(*) AS 超过50的课程数目 FROM dbo.Subject GROUP BY Gradeid HAVING SUM(ClassHour)>50--NO.2SELECT Gradeid AS 学期,AVG(DATEDIFF(dd,BornDate,GETDATE())/365) AS 平均年龄 FR

--上机练习一--NO.1SELECT SUM(ClassHour) AS 总学时数 FROM Subject GROUP BY Gradeid ORDER BY SUM(ClassHour) --NO.2SELECT AVG(StudentResult) AS 平均分 FROM Result GROUP BY StudentNo ORDER BY AVG(StudentResu