CREATE FUNCTION [dbo].[GetSubjectFromClass] 
(  
  -- Add the parameters for the function here
  @classId int
)
RETURNS int 
AS
BEGIN
 
  SELECT TOP 1 SubjectID
  FROM (
    SELECT TOP 1 QuestionID
    FROM
      (
      SELECT TOP 1 ExamVersionID
      FROM  (
          SELECT TOP 1 ExamID
          FROM ClassExams
          WHERE ClassID = @classId
          ) A
      INNER JOIN ExamVersions
      ON ExamVersions.ExamID = A.ExamID
      ) B
    INNER JOIN ExamQuestions
    ON ExamQuestions.ExamVersionID = B.ExamVersionID
    ) C
  INNER JOIN Questions
  ON Questions.QuestionID = C.QuestionID
 
RETURN 
END