Advertisement
Guest User

Untitled

a guest
Feb 25th, 2020
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. SELECT avg(brojpoena) AS "Prosecno poena" FROM statistika;
  2. SELECT SUM(brojpoena) AS "Ukupan broj poena" FROM statistika;
  3. SELECT AVG(brojpoena) AS "Prosecan broj poena za sut preko 0.4" FROM statistika WHERE procenat>0.4;
  4. SELECT COUNT ( DISTINCT ime ) FROM statistika GROUP BY Tim;
  5. SELECT AVG(BrojSuteva) AS "Prosecan broj suteva Jaramaza" FROM statistika WHERE Ime='Jaramaz';
  6. SELECT SUM(brojpoena) AS "UKupan broj suteva zvezde" FROM statistika WHERE Tim='Zvezda';
  7. SELECT COUNT ( DISTINCT Tim ) FROM statistika;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement