Для заданной дисциплины определить список студентов заданного учебного года, не получивших неудовлетворительных оценок по заданному виду контрольного мероприятия
SELECT DISTINCT T_STUDENT.FIO
FROM WASTELAND.t_disc AS t_disc
Inner Join wasteland.t_lesson t_lesson On t_lesson.id_disc=t_disc.id_disc and t_disc.name = 'бд'
Inner Join wasteland.t_exercise t_exercise On t_exercise.id_lesson=t_lesson.id_lesson
Inner join wasteland.t_typeexercise t_typeexercise On t_typeexercise.id_typeexercise=t_exercise.id_typeexercise and t_typeexercise.name_type = 'Самостоятельная'
Inner Join wasteland.t_cenz t_cenz On t_cenz.id_exercise=t_exercise.id_exercise and t_cenz.cenz > 2
Inner Join wasteland.t_student t_student On t_student.id_student=t_cenz.id_student
where 0= (select count(1)from t_learngroup, t_disc
Inner Join wasteland.t_lesson t_lesson On t_lesson.id_disc=t_disc.id_disc and t_disc.name = 'бд'
Inner Join wasteland.t_exercise t_exercise On t_exercise.id_lesson=t_lesson.id_lesson
Inner join wasteland.t_typeexercise t_typeexercise On t_typeexercise.id_typeexercise=t_exercise.id_typeexercise and t_typeexercise.name_type = 'Самостоятельная'
Inner Join wasteland.t_cenz t_cenz On t_cenz.id_exercise=t_exercise.id_exercise and t_cenz.cenz = 2
where id_student=t_student.id_student and t_learngroup.learn_yaer = '2006-2007' )