Advertisement
Guest User

Untitled

a guest
Oct 17th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. SELECT TYTUL,
  2. ROUND(MIN(DATA_ZWROTU::DATE - DATA_WYPOZYCZENIA::DATE),1) MIN,
  3. ROUND(MAX(DATA_ZWROTU::DATE - DATA_WYPOZYCZENIA::DATE),1) MAX,
  4. ROUND(AVG(DATA_ZWROTU::DATE - DATA_WYPOZYCZENIA::DATE),1) sre,
  5. COUNT(DATA_WYPOZYCZENIA) razy
  6. FROM WYPOZYCZENIA NATURAL JOIN KOPIE
  7. NATURAL JOIN FILMY
  8. GROUP BY TYTUL
  9. ORDER BY RAZY DESC, SRE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement