Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How many rows will the following SQL statement return given the Employee and Department tables shown? SELECT EMP_NAME, EMP_JOB FROM EMPLOYEE WHERE EMP_JOB = 'Manager'
How many rows will the following SQL statement return given the Employee and Department tables shown?
SELECT EMP_NAME, EMP_JOB
FROM EMPLOYEE
WHERE EMP_JOB = 'Manager' OR DEP_NO = 30;
DEPARTMENT EMPLOYEE DEP NOI DEP NAMEB DEP LOCATION | EMP ID?EMP 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 10Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started