查询各个员工的员工号，员工名及其所在部门的平均工资

 select employeeid, firstname, d.avgsal
                  from employee,
                 (select departmentid, avg(salary)
                    from employee
                   group by departmentid) d
                 where employee.departmentid = d.departmentid