Hi . How can I change this SQL query to LINQ :

SELECT SUM(Grades.Grade * Lessons.LesTotalUnit) / SUM(Lessons.LesTotalUnit) AS avg FROM Grades INNER JOIN Lessons ON Grades.LesCode = Lessons.LesCode WHERE (Grades.StNo = @stno) AND (Grades.EduYear IN (SELECT MAX(EduYear) AS Expr1 FROM Grades AS Grades_1 WHERE (StNo = @stno))) AND (Grades.Semester IN (SELECT MAX(Semester) AS Expr1 FROM Grades AS Grades_2 WHERE (StNo = @stno) AND (EduYear IN (SELECT MAX(EduYear) AS Expr1 FROM Grades AS Grades_3 WHERE (StNo = @stno)))))