Answered step by step
Verified Expert Solution
Link Copied!

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;

image text in transcribed

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 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2022 Grenoble France September 19 23 2022 Proceedings Part 4 Lnai 13716

Authors: Massih-Reza Amini ,Stephane Canu ,Asja Fischer ,Tias Guns ,Petra Kralj Novak ,Grigorios Tsoumakas

1st Edition

3031264118, 978-3031264115

More Books

Students also viewed these Databases questions