Question: How many rows will the following SQL statement return given the Employee and Department tables shown? SELECT EMP_NAME, EMP_JOB FROM EMPLOYEE emp, DEPARTMENT dep WHERE
How many rows will the following SQL statement return given the Employee and Department tables shown?
SELECT EMP_NAME, EMP_JOB
FROM EMPLOYEE emp, DEPARTMENT dep
WHERE emp.DEP_NO = dep.DEP_NO AND
dep.DEP_LOCATION = 'Boston';

DEPARTMENT EMPLOYEE DEP NOI DEP NAMEB DEP LOCATION | EMP IDEMP NAME DEP NO 10 EMP-JOB 10 AccourtingNew York 20 Research 30 Sales 40 Cperations 7839 King 7566 Jones 7698 Blake 7782 Clark 7902 Ford 7369 Smith 7499 Allen 7521 Ward 7654 Martin 7788 Scott 7844 Turner 7876 Adams 7900 James 7934 Miller President Manager Manager Manager Analyst Clerk Salesman Salesman Salesman Analyst Salesman Clerk Clerk Clerk Dallas Dallas Boston 20 2 3 10 20 20 30 30 30 20 Important: Dep no in EMPLOYEE is the foreign key that references the primary key Dep_no in DEPARTMENT. 10 20 12 13 14 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
