Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT avg(brojpoena) AS "Prosecno poena" FROM statistika;
- SELECT SUM(brojpoena) AS "Ukupan broj poena" FROM statistika;
- SELECT AVG(brojpoena) AS "Prosecan broj poena za sut preko 0.4" FROM statistika WHERE procenat>0.4;
- SELECT COUNT ( DISTINCT ime ) FROM statistika GROUP BY Tim;
- SELECT AVG(BrojSuteva) AS "Prosecan broj suteva Jaramaza" FROM statistika WHERE Ime='Jaramaz';
- SELECT SUM(brojpoena) AS "UKupan broj suteva zvezde" FROM statistika WHERE Tim='Zvezda';
- SELECT COUNT ( DISTINCT Tim ) FROM statistika;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement