以下问题基于员工表（emp）和部门表（dept）,写出相应的SQL语句。

6) SELECT EMPNO, ENAME
FROM emp, dept
WHERE emp.DEPTNO = dept.DEPTNO
AND dept.DNAME = 'SALES'

7) INSERT INTO emp(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
VALUES(7935, 'David', 'CLERK', 7902, '01-5月-81', 1800, 300, 20)

INSERT INTO dept(DEPTNO, DNAME, LOC) VALUES(50, 'HR', 'Paris')

8) SELECT DEPTNO, COUNT(*) AS totalStaff, SUM(SAL) AS totalSalary
FROM dept LEFT JOIN emp
ON dept.DEPTNO = emp.DEPTNO
GROUP BY DEPTNO

9) SELECT empno,ename,job,hiredate, dept.deptno,dept.dname,loc
FROM emp, dept
WHERE emp.DEPTNO = dept.DEPTNO
AND hireDate > '06-01-1981'
这里的日期大小不同SQL方言可能要适当变动，

10) UPDATE emp SET sal = sal * 110% WHERE SAL < 1800

问题不全 怎么回答啊 ？ 就算我写的代码你也不能用啊 你干脆把题完整的发到网上 让我上机做完再发你标准答案吧