一道数据库题求助，急用，需要详细答案，在线等，多谢各位大侠！！

你好，我按照你的要求，写的如下SQL语句：

select * from EMPLOYEE having EMP_ID in (select EMP_ID from ASSET,ASSET_REPORT where ASSET.AST_ID=ASSET_REPORT.AST_ID and getDate()>REP_DATE and AST_NAME='notebook') by DEP_NAME asc

简单解释下，(...)里的是获得满足是笔记本、且已过期的员工ID，在外面一层是获得这些ID属于的员工信息，并按部门编号排序

6、

SELECT E#，COUNT(C#) AS NUM，SUM(SALARY) AS SUM_SALARY

FROM WORKS GROUP BY E#；

7、

SELECT X.E# FROM WORKS X WHERE NOT EXISTS

(SELECT * FROM WORKS Y WHERE E#=‘E6’AND NOT EXISTS

(SELECT * FROM WORKS Z WHERE Z.E#=X.E# AND Z.C#=Y.C#))；

---