Advertisement
Guest User

Untitled

a guest
Feb 21st, 2020
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. select grupa,an from (
  2. select t1.cnt1/t2.cnt2, t1.grupa, t1.an from
  3. (select count(*) as cnt1, s1.grupa, s1.an from
  4. studenti s1 join prieteni p on s1.id=p.id_student1 join studenti s2
  5. on s2.id = p.id_student2 and s1.grupa=s2.grupa and s1.an=s2.an
  6. group by s1.grupa, s1.an) t1
  7. join
  8. (select count(*) as cnt2, grupa, an from studenti
  9. group by grupa,an) t2
  10. on t1.an=t2.an and t1.grupa=t2.grupa order by 1 desc) where rownum=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement