130 Corporate Tax 170 Manufacturing 180 Construction ODEPARTMENTS Columne Data Model IConstraints Grants Istatetics Triopers Pahback Dependences IDetals *a X Sort Fiter DEPARTMENT. DEPARTHENT NAME MANAGER DLOCATIONJD 1700 10 Adminiatration n 200 20 Marketing 201 2800 30 Purchasing 114 1700 4. 40 Human Resources 203 2400 S0 Shapping 40 IT 70 Publie Relationa 121 1500 6. 103 1400 204 2700 80 Sales 145 2500 9. 90 Executave 100 1700 10 100 Fanance 108 8 1700 11 110 Accounting 205 1700 12 120 Treasury (null) 1700 13 (nuil) 1700 14 140 Control And Credit (null) 1700 15 150 Shareholder Services (null) 1700 16 140 Benetita (null) 1700 17 (null) 1700 18 (null) 1700 19 190 Contracting (nul1) 1700 20 200 Operations (null) 1700 21 1700 210 IT Support 220 NOC (null) 22 (null) (null) 1700 23 230 IT Helpdesk 1700 Departments ) DHPLOYEE_ JD () PIRST_JNAME () LAST NAME () EMAR. 0PHONE NUMER SALARY COMMESSION PCT MANAGER JD 0 HORE DATE 0J08D 21-SEP-89 AD_VP 13-JAN-93 AD VP 17000 17000 11000 7900 8600 (null) (null) 101 Neena Kochhar SROCHHAR S15.123.4568 100 102 Lex De Haan LOENAAN S15.123.4569 100 114 Den Raphaely DRAPHEAL S15.127.4561 Kaufling PRAUFLIN 650.123.3234 07-Dec-94 FU MAN (null) 100 01-MAY-95 ST MAN JTAYLOR O11.44.1644.429265 24-AR-90 SA REP 17-SEP-87 AD_ASST 17-PEB-96 MK MAN 122 Payan (null) 100 176 Jonathon Taylor 0.2 149 200 Jennifer Whaien JWHALEN S15.123.4444 4400 (null) 101 201 Michael Hartstein MIARTSTE S15.123.5555 13000 (null) 100 Cemployees What SQL statement will show the last name and the department name of Payan Kaufling? SELECT CLast name, D.Department_name FROM DEPARTMENTS D UNION JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling': • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D INNER JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling' AND C.FIRST NAME = "Payan'; ; SELECT C.Last name, D.Department_name FROM DEPARTMENTSD INNER JOIN CEMPLOYEES C WHERE C.LAST NAME = "KAUFLING' AND C.FIRST NAME = 'PAYAN'; • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D AND CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST_NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';
130 Corporate Tax 170 Manufacturing 180 Construction ODEPARTMENTS Columne Data Model IConstraints Grants Istatetics Triopers Pahback Dependences IDetals *a X Sort Fiter DEPARTMENT. DEPARTHENT NAME MANAGER DLOCATIONJD 1700 10 Adminiatration n 200 20 Marketing 201 2800 30 Purchasing 114 1700 4. 40 Human Resources 203 2400 S0 Shapping 40 IT 70 Publie Relationa 121 1500 6. 103 1400 204 2700 80 Sales 145 2500 9. 90 Executave 100 1700 10 100 Fanance 108 8 1700 11 110 Accounting 205 1700 12 120 Treasury (null) 1700 13 (nuil) 1700 14 140 Control And Credit (null) 1700 15 150 Shareholder Services (null) 1700 16 140 Benetita (null) 1700 17 (null) 1700 18 (null) 1700 19 190 Contracting (nul1) 1700 20 200 Operations (null) 1700 21 1700 210 IT Support 220 NOC (null) 22 (null) (null) 1700 23 230 IT Helpdesk 1700 Departments ) DHPLOYEE_ JD () PIRST_JNAME () LAST NAME () EMAR. 0PHONE NUMER SALARY COMMESSION PCT MANAGER JD 0 HORE DATE 0J08D 21-SEP-89 AD_VP 13-JAN-93 AD VP 17000 17000 11000 7900 8600 (null) (null) 101 Neena Kochhar SROCHHAR S15.123.4568 100 102 Lex De Haan LOENAAN S15.123.4569 100 114 Den Raphaely DRAPHEAL S15.127.4561 Kaufling PRAUFLIN 650.123.3234 07-Dec-94 FU MAN (null) 100 01-MAY-95 ST MAN JTAYLOR O11.44.1644.429265 24-AR-90 SA REP 17-SEP-87 AD_ASST 17-PEB-96 MK MAN 122 Payan (null) 100 176 Jonathon Taylor 0.2 149 200 Jennifer Whaien JWHALEN S15.123.4444 4400 (null) 101 201 Michael Hartstein MIARTSTE S15.123.5555 13000 (null) 100 Cemployees What SQL statement will show the last name and the department name of Payan Kaufling? SELECT CLast name, D.Department_name FROM DEPARTMENTS D UNION JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling': • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D INNER JOIN CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST NAME = 'Kaufling' AND C.FIRST NAME = "Payan'; ; SELECT C.Last name, D.Department_name FROM DEPARTMENTSD INNER JOIN CEMPLOYEES C WHERE C.LAST NAME = "KAUFLING' AND C.FIRST NAME = 'PAYAN'; • SELECT C.Last_name, D.Department_name FROM DEPARTMENTS D AND CEMPLOYEES C WHERE D.DEPARTMENT ID = C.DEPARTMENT ID AND C.LAST_NAME = 'Kaufling' AND C.FIRST_NAME = 'Payan';
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education