Question

根据EMP, DEPT表，自拟5道难度适中的SQL题目并给出评分标准

请发到 邮箱 IcDragon@163.com
谢了

Answer 1

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
另外,团IDC网上有许多产品团购,便宜有口碑

Answer 2

你这个问的是啥啊 这两个表是什么样的