SELECT student.br_index,
       student.nasoka,
       student.prezime,
       student.ime,
       Avg(ocena.ocena)
FROM   predmet,
       student,
       ocena
WHERE
       student.br_index = ocena.br_index
GROUP  BY student.br_index
HAVING Avg (ocena.ocena) > 8 AND Avg (ocena.ocena) < 9
ORDER  BY student.br_index DESC;