1. select avg(elisten) as elisten,avg(egrammar) as egrammar,avg(ewrite) asewrite from exam 2. select eyear,emonth from exam group by eyear,emonth having count(*)>5 3. select b.suniname,avg(a.ewrite) as ewrite from exam a, stud b where a.sid=b.sid and a.eyear='2001' and a.emonth='7' group by b.suniname5.select... |