Exercise 3-2-7

Find the departments without employees and list the department numbers (DEPTNO) and department names (DNAME). (scott/tiger) 請找出沒有員工的部門，並列出部門代碼(DEPTNO)與部門名稱(DNAME)。(scott/tiger)

Evaluate responses using AI:

OFF

Find the department numbers where no employees sought medical treatment in the hospital in September year 90. (reg, med, emp) 請找出90年9月份沒有員工在院內就診的部門代碼。(reg, med, emp)

Evaluate responses using AI:

OFF

From the employees in other departments, find those with a salary (SAL) higher than the highest salary (MAX(SAL)) in department 30, and list their employee numbers (EMPNO), employee names (ENAME), and salaries (SAL) in descending order by salary. (scott/tiger) 請找出其他部門的員工中，薪資(SAL)高於部門30的最高薪資(MAX(SAL))，並依薪資(SAL)降冪排序列出其員工代碼(EMPNO)、員工姓名(ENAME)與薪資(SAL)。(scott)

Evaluate responses using AI:

OFF

Find those with a salary higher than any employee in department 30. (scott/tiger) 同上，請找出薪資比部門30中任一員工薪資高的資料(soctt/tiger)

Evaluate responses using AI:

OFF

Find other employees who have the same job (JOB) and department (DEPTNO) as SMITH, and list their employee numbers (EMPNO), employee names (ENAME), job titles (JOB), and salaries (SAL). (scott/tiger) 找出其他員工與SMITH有著相同職位(JOB)和部門(DEPTNO)的員工，並列出員工代碼(EMPNO)、員工姓名(ENAME)、職位(JOB)和薪資(SAL)。(scott/tiger)

Evaluate responses using AI:

OFF