SQL数据库经典面试题(笔试题)（有答案）.pdfVIP

28. 数据库：抽出部门，平均工资，要求按部门的字符串顺序排序，不能含有human resource” 部门， employee 结构如下：employee_ id, employee_ name, depart_ id,depart_ name,wage 答： select depart_ name, avg(wage) from employee where depart_ name human resource group by depart_ name order by depart_ name 29. 定如下SQL数据