SELECT student.recordbook_num as "№ зач. книжки", 
       student.FIO AS "ФИО",
       stgroup.group_code AS "Код группы"  
FROM student 
              INNER JOIN (SELECT x.recbook as rcrdbk
                          FROM (SELECT y.rb_n AS recbook, 
                                       COUNT(grade_id) AS cnt, 
                                       grade.grade AS grd 
                               FROM (SELECT student.recordbook_num AS rb_n, 
                                            SUM(absence.withoutvalidreason) AS wovr 
                                     FROM student 
                                          INNER JOIN absence ON absence.recordbook_num=student.recordbook_num
                                     GROUP BY student.recordbook_num) y 
                               INNER JOIN wastopass ON y.rb_n=wastopass.recordbook_num 
                               INNER JOIN grade ON grade.wtp_id=wastopass.wtp_id
                          WHERE y.wovr = 0 
                                AND (wtptype='экз'
                                    OR wtptype='кр'
                                    OR wtptype='кп')
                          GROUP BY y.rb_n, 
                                   grade.grade) x
                         WHERE x.grd='уд' 
                               AND x.cnt=(SELECT MIN(COUNT(wastopass.wtp_id)) 
                                          FROM wastopass 
                                               INNER JOIN stsession on wastopass.session_id=stsession.session_id
                                          WHERE (wastopass.wtptype='экз' 
                                                OR wastopass.wtptype='кр'
                                                OR wastopass.wtptype='кп')
                                                AND stsession.session_id=1
                                          GROUP BY stsession.session_id, 
                                                   recordbook_num)) z ON z.rcrdbk=student.recordbook_num
               INNER JOIN stgroup ON student.group_id=stgroup.group_id;