Запрос на выборку нужного поля

USE Sergey
SELECT top 1 gruppa, Fakultet.nazvanie AS 'Факультет', Prepodavatel.familiya_prepodavatelya AS 'Фамилия преподавателя', Student.familiya_studenta AS 'Фамилия студента'
FROM Kafedra, Fakultet, Prepodavatel, Student, Zadanie
WHERE Fakultet.fakultet_id=Kafedra.fakultet_id 
AND Kafedra.kafedra_id=Prepodavatel.kafedra_id
AND Prepodavatel.prepodavatel_id=Zadanie.prepodavatel_id
AND Zadanie.zadanie_id=student.zadanie_id
AND student.familiya_studenta='Petrov'
AND prepodavatel.familiya_prepodavatelya='Ivanov'
GROUP BY gruppa,Fakultet.nazvanie, Prepodavatel.familiya_prepodavatelya, Student.familiya_studenta
ORDER BY COUNT(gruppa) DESC;

SELECT top 1 Fakultet.nazvanie, Prepodavatel.familiya_prepodavatelya,Student.familiya_studenta,
    (SELECT COUNT(*) FROM Student S1 WHERE S1.gruppa=Student.gruppa) AS CountStud
  FROM Kafedra, Fakultet, Prepodavatel, Student, Zadanie
  WHERE Fakultet.fakultet_id=Kafedra.fakultet_id AND
        Kafedra.kafedra_id=Prepodavatel.kafedra_id AND
        Prepodavatel.prepodavatel_id=Zadanie.prepodavatel_id AND
        Zadanie.zadanie_id=student.zadanie_id AND
        student.familiya_studenta='Petrov' AND
        prepodavatel.familiya_prepodavatelya='Ivanov'
  ORDER BY 4 DESC

SELECT top 2 gruppa