Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT S.NAZWA,(SELECT ROUND(AVG(KWOTAMANDATU), 2) FROM WYKROCZENIA) SR
- FROM STOPIEN S
- WHERE S.NAZWA NOT LIKE 'P%'
- ORDER BY SR DESC;
- ----------------------------
- SELECT NAZWISKO, IMIE, PESEL, DATAW, NAZWAWYKROCZENIA
- FROM SPRAWCA, WYKROCZENIA, TARYFIKATOR
- WHERE KWOTAMANDATU > (SELECT AVG(KWOTAMANDATU) FROM WYKROCZENIA) * 0.4
- AND DATAW BETWEEN '17/01/01' AND '17/06/30'
- ORDER BY KWOTAMANDATU DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement