SELECT
    PERSON.PERSON_ID
   ,PERSON.PERSON_LASTNAME
   ,PERSON.PERSON_FIRSTNAME
   ,PERSON.PERSON_FATHERNAME
   ,CHAIR.CHAIR_SHORTNAME
   ,TIP.TIP_TOTALFACT
  FROM PERSON
  INNER JOIN EMPLOYEEDBGUPS
    ON PERSON.PERSON_ID = EMPLOYEEDBGUPS.PERSON_ID
  INNER JOIN TEACHERCHAIR
    ON EMPLOYEEDBGUPS.EMPLOYEEDBGUPS_ID = TEACHERCHAIR.TEACHERCHAIR_EMPLOYEEDBGUPS_ID
  INNER JOIN CHAIR
    ON TEACHERCHAIR.TEACHERCHAIR_CHAIR_ID = CHAIR.CHAIR_ID
  INNER JOIN TIP
    ON TEACHERCHAIR.TEACHERCHAIR_ID = TIP.TEACHERCHAIR_ID
  WHERE TIP.STUDYEAR_ID = @STUDYEAR_ID
  AND TIP.TIP_TOTALFACT > 0