数据库:抽出部门,平均工资,要求按部门的字符串顺序排序,不能含有"human resource"部门,
employee结构如下:employee_id, employee_name, depart_id,depart_name,wage
答:select depart_name, avg(wage)from employeewhere depart_name <> 'human resource'group by depart_nameorder by depart_name