---

SELECT
	Students.ID,
	Students.Surname,
	Students.FullName,
	Groups.GroupName,
	Groups.CourseNumber
FROM Students
JOIN Groups ON Students.GroupID = Groups.ID
JOIN Grades ON Grades.StudentID = Students.ID
JOIN Lessons ON Grades.LessonID = Lessons.ID
JOIN Subjects ON Lessons.SubjectID = SubjectS.ID
WHERE Groups.CourseNumber IN (3,4) 
AND Subjects.SubjectName IN ("Русский язык","Литература","Русский язык и культура речи","История","История России")
AND Groups.GroupName LIKE 'ИСИП%'
AND (Lessons.LessonDate LIKE '24.09.2026%' OR Lessons.LessonDate LIKE '25.09.2026%')
AND Grades.GradeName IN ('good','excellent') AND length(Students.Surname) <= 8;