SHARE
TWEET

DB

a guest Dec 6th, 2019 110 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT S.NAZWA,(SELECT ROUND(AVG(KWOTAMANDATU), 2) FROM WYKROCZENIA) SR
  2. FROM STOPIEN S
  3. WHERE S.NAZWA NOT LIKE 'P%'
  4. ORDER BY SR DESC;
  5. ----------------------------
  6. SELECT NAZWISKO, IMIE, PESEL, DATAW, NAZWAWYKROCZENIA
  7. FROM SPRAWCA, WYKROCZENIA, TARYFIKATOR
  8. WHERE KWOTAMANDATU > (SELECT AVG(KWOTAMANDATU) FROM WYKROCZENIA) * 0.4
  9. AND DATAW BETWEEN '17/01/01' AND '17/06/30'
  10. ORDER BY KWOTAMANDATU DESC;
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