t.sql

SELECT "S"."ФИО"

FROM "Студент" AS "S", "Результат" AS "R", 


(SELECT "Код" FROM "Ведомость" 
	WHERE "Предмет" = 3 AND "Дата" >= {D '2007-01-01' } 
			    AND "Дата" <= {D '2007-06-01' }
) AS "V"


WHERE

        "R"."Оценка"    = 5 
    AND "R"."Ведомость" = "V"."Код" 
    AND "R"."Студент"   = "S"."№ зачетки"

GROUP BY "S"."ФИО"

HAVING COUNT("V"."Код") = 2