1、
SELECT
e.depid,avg(s.bonussalary+s.basesalary) AS avgsal from employ e,salary s
where e.employId=s.employId GROUP BY e.depid
ORDER BY avgsal asc
注意顺序 select from where group by oder by
2、
SELECT * from employ e where e.ename like ‘王%‘
原文：http://www.cnblogs.com/angle-happy/p/6700462.html