Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 3a
- SELECT SUM(p.il_zam) FROM POZYCJE_ZAMOWIEN4 p join WYROBY2 w
- on p.kod_w = w.kod_w WHERE w.nazwa_w = 'gwoździe';
- 3b
- SELECT Nr_zam, data_zam, id_kl, zam_og FROM ZAMOWIENIA2
- WHERE zam_og > (SELECT avg(zam_og) FROM ZAMOWIENIA2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement