62,041
社区成员
发帖
与我相关
我的任务
分享
select StudyTime,StudentRN,A.StudentID,CreditHour,A.DepartmentName,A.ItemName from (SELECT SUM(T.StudyTime) as StudyTime ,S.StudentRN, T.StudentID,D.DepartmentName,ItemName FROM TB_ONLINESTUDY_StuCourStiTime AS T INNER JOIN TB_ONLINESTUDY_Student AS S ON T.StudentID=S.StudentID INNER JOIN TB_ONLINESTUDY_Department as D on S.DepartmentID=D.DepartmentID INNER JOIN TB_ONLINESTUDY_Item AS I ON T.ItemID=I.ItemID WHERE NOT(S.StudentName like 'lly%') GROUP BY T.StudentID,S.StudentRN,D.DepartmentName,ItemName) as A inner join (select Sum(CreditHour) as CreditHour,T.StudentID from TB_ONLINESTUDY_Item_Course_Relation as CR inner join (select (Sum(StudyTime)/60) as StudyTime,CourseID,StudentID from TB_ONLINESTUDY_StuCourStiTime GROUP BY StudentID,CourseID ) AS T on CR.CourseID=T.CourseID GROUP BY T.StudentID ) as B on A.StudentID=B.StudentID ORDER BY StudyTime DESC