Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT (DISTINCT p.nr_prac)
- FROM Pracownicy p, Zespoly z, Tematy t
- WHERE (z.nr_prac_kz = p.nr_prac OR t.nr_prac_kt = p.nr_prac)
- AND
- p.nr_zesp =
- (SELECT z.nr_zesp
- FROM Zespoly z
- WHERE z.nr_inst =
- (SELECT i.nr_inst
- FROM Instytuty i
- WHERE i.nazwa_inst LIKE 'AUTOMATYKA')
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement