SELECT S.br_index,
       S.prezime,
       A.avg
FROM   student S
       INNER JOIN (SELECT br_index,
                          Avg(ocena) AS AVG
                   FROM   ocena
                   GROUP  BY br_index
               ON S.br_index = A.br_index;
WHERE A.avg > 7 AND A.avg < 8