Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW "widok" ("id_filmu","placa","imie","nazwisko") AS
- SELECT COUNT(f.id_filmu), SUM(k.placa), o.imie, o.naziwsko
- FROM film f, kontrakt k, osoba o, typ_osoby t
- WHERE f.id_filmu = k.id_filmu AND k.id_osoby = o.id_osoby AND
- o.kod_osoby = t.kod_osoby AND t.typ_osoby = 'rezyser'
- GROUP BY f.id_filmu,k.placa,o.imie,o.nazwisko;
- SELECT nazwisko, SUM(placa) FROM widok WHERE placa < (SELECT SUM(placa) FROM widok WHERE nazwisko = 'zadane nazwisko')
- GROUP BY nazwisko,placa;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement