求助sql to linq

[非物质文化遗产小明同学]

              SELECT a.QuestionId,QuestionType,Title,a.OptionA,a.OptionB,a.OptionC,a.OptionD,
				a.ROptionA,a.ROptionB,a.ROptionC,a.ROptionD,a.EasyLevel,NationalVocational,
				--答题总次数
				b.QuestionTotalCount,
				--答对的比例
				ISNULL(Round(CAST(c.QuestionTotalReusltCount AS NUMERIC(18,2)) / CAST(b.QuestionTotalCount AS NUMERIC(18,2)),2 ),0) AS OK,
				--答错的比例
				1-(ISNULL(Round(CAST(c.QuestionTotalReusltCount AS NUMERIC(18,2)) / CAST(b.QuestionTotalCount AS NUMERIC(18,2)),2 ),0))  AS No,
				--最后的时间
				CreateDate
				FROM dbo.QuestionInfo a 
				--答题总数
				LEFT JOIN (
					SELECT QuestionId,COUNT(Result) QuestionTotalCount,MAX(b1.CreateDate) CreateDate
					FROM QuestionRecord q1 
					JOIN (
						SELECT CoachQuestionCollectionRId,CreateDate FROM CoachQuestionCollectionR 
					) b1 ON b1.CoachQuestionCollectionRId = q1.CoachQuestionCollectionRId
					GROUP BY QuestionId
				) b ON b.QuestionId = a.QuestionId
				--答题正确的总数
				LEFT JOIN (
					SELECT QuestionId,SUM(1) QuestionTotalReusltCount 
					FROM QuestionRecord 
					WHERE Result = 1
					GROUP BY QuestionId
				) c ON c.QuestionId = a.QuestionId

[非物质文化遗产小明同学]

或者请教

 
SELECT QuestionId,COUNT(Result) QuestionTotalCount,MAX(b1.CreateDate) CreateDate
FROM QuestionRecord q1 
JOIN (
SELECT CoachQuestionCollectionRId,CreateDate FROM CoachQuestionCollectionR 
) b1 ON b1.CoachQuestionCollectionRId = q1.CoachQuestionCollectionRId
GROUP BY QuestionId

这样的linq语法怎么写

[非物质文化遗产小明同学]