Use the following table(s) as appropriate to answer the following questions. Dep

Question

Use the following table(s) as appropriate to answer the following questions. Dept deptno dname integer text loc comm deptno integer integer integer hiredate sal empno ename Job integer text integer text 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES 40 OPERATIONS BOSTON 30 7698 1981-02-20 7839 1981-05-01 7698 1981-09-28 nu 1981-11-17 7698 1981-09-08 7566 1981-12-03 7698 1981-02-22 7566 1982-12-09 7782 1982-01-23 7902 1980-12-17 7698 1981-12-03 7839 1981-04.02 7788 1983-01-12 839 1981-06-09 1600 2850 [nul) 1250 1400 5000 tnu 500 [null] 3000 [nul] 1250 3000 null 1300 nu 800 Inulit) 950 null) 2975 [nuil 1100 null 2450 null) 300 7499 ALLEN SALESMAN 7698 BLAKE MANAGER 7654 MARTIN SALESMAN 7839 KING PRESIDENT 7844 TURNER SALESMAN 7902 FORD ANALYST 7521 WARD SALESMAN 7788 SCOTT ANALYST 7934 MILLER CLERK 7369 SMITH CLERK 7900 JAMES CLERK 7566 JONES MANAGER 7876 ADAMS CLERK 7782 CLARK MANAGER 30 10 30 20 30 500 30 20 Write the sQL that would print each job title just once. Write the SQL that would print all of the employee names and optionally the department location if one exists for the employee.

Explanation / Answer

1. select distinct job from Emp;

2. select Emp.ename,dept.loc from Emp LEFT JOIN Dept ON Dept.deptno = Emp.deptno;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.