daily pastebin goal
24%
SHARE
TWEET

Untitled

a guest May 17th, 2018 110 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. PRACOWNICY.NAZWISKO, ETATY.ETAT FROM PRACOWNICY
  2. INNER JOIN ETATY ON PRACOWNICY.ID_ETATU = ETATY.ID_ETATU;
  3.  
  4. SELECT KLIENCI.NAZWA, ZAMOWIENIA.WARTOSC FROM KLIENCI
  5. INNER JOIN ZAMOWIENIA ON ZAMOWIENIA.ID_ZAMOWIENIA = KLIENCI.ID_ZAMOWIENIA
  6. WHERE ZAMOWIENIA.WARTOSC BETWEEN 1000 AND 3000 AND ZAMOWIENIA.DATA_ZAMOWIENIA > TO_DATE('10-05-1991', 'DD-MM-YYYY')
  7. ORDER BY ZAMOWIENIA.WARTOSC ASC;
  8.  
  9. SELECT KLIENCI.NAZWA, AVG(ZAMOWIENIA.WARTOSC) FROM KLIENCI
  10. INNER JOIN ZAMOWIENIA ON ZAMOWIENIA.ID_ZAMOWIENIA
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top