Сформировать списки студентов, у которых в заданный учебный период проводит занятия заданный преподаватель. В отчете указать ФИО студента, название учебной группы, название дисциплины
Select t_student.fio_student, t_institut.sec_name as inst, t_spec.sec_name as spec, t_specs.sec_name as specs, t_formlearn.sec_name as formlearn,
t_learngroup.kurs, t_learngroup.group, t_disc.full_name as disc
From t_lesson
Inner Join t_disc On t_disc.id_disc=t_lesson.id_disc
Inner Join t_learngroup On t_learngroup.id_learngroup=t_lesson.id_learngroup
Inner Join t_student On t_learngroup.id_learngroup=t_student.id_learngroup
Inner Join t_institut On t_learngroup.id_institut=t_institut.id_institut
Inner Join t_spec On t_learngroup.id_spec=t_spec.id_spec
Inner Join t_specs On t_learngroup.id_specs=t_specs.id_specs
Inner Join t_formlearn On t_learngroup.id_formlearn=t_formlearn.id_formlearn
Where t_lesson.id_lector=1 and t_lesson.lesson_begin>'2007-01-01 9:00:00' and t_lesson.lesson_end<'2008-06-01 15:00:00'
Group By t_institut.sec_name, t_spec.sec_name, t_specs.sec_name, t_formlearn.sec_name, t_learngroup.kurs, t_learngroup.group, t_disc.full_name, t_student.fio_student