select nazpredmet, ectsbod, ((select count(p1.sifpredmet) from predmet  p1 where p1.ectsbod = predmet.ectsbod)) as ostali from predmet
where ukbrsatitjedno<(select AVG(predmet.ukbrsatitjedno) from predmet) and ectsbod is not null
group by nazpredmet, ectsbod
order by nazpredmet asc