Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.23 KB | None | 0 0
  1. 3a
  2. SELECT SUM(p.il_zam) FROM POZYCJE_ZAMOWIEN4 p join WYROBY2 w
  3. on p.kod_w = w.kod_w WHERE w.nazwa_w = 'gwoździe';
  4. 3b
  5. SELECT Nr_zam, data_zam, id_kl, zam_og FROM ZAMOWIENIA2
  6. WHERE zam_og > (SELECT avg(zam_og) FROM ZAMOWIENIA2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement