Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- tridy_trida AS `Trida`,
- COUNT(*) AS `Počet studentů`,
- ROUND(AVG(absence),1) AS `Průměrná absence`
- FROM `studenti`
- GROUP BY tridy_trida
- HAVING `Průměrná absence` > (SELECT AVG(absence) FROM `studenti`)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement