خبرگزاری آیصد (جدیدترین و جذاب ترین اخبار ایران و جهان)

نشر توسط:admin Views 30 تاریخ : 31 ارديبهشت 1395

نظرات ()

بدست آوردن معدل فردی با شماره شناسائی 1 در ترم اول سال 1389

select (sum(sum1) * 1.0) / (select sum(T3.UnitLessons) from (select UnitCount as UnitLessons from Term Inner Join Lesson On Term.IDLesson = Lesson.IDLesson WHere Term.IDPerson = 1 AND Term.TermYear = 1389 AND Term.ISFirstTerm  = 1) as T3) as Average
from
(select TL.IDLesson, TL.Grade * Lesson.UnitCount as sum1
 from
Term as TL Inner join Lesson On TL.IDLesson = Lesson.IDLesson where TL.IDPerson = 1AND TL.TermYear = 1389 AND TL.ISFirstTerm  = 1) as T1