Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Which query returns the first 3 characters of last name of the manager who work with employee named as Hülya? O a. SELECT SUBSTR(First_name, 1,3) FROM Manager WHERE Mngr_Code=D (SELECT Mngr_Code FROM Employees WHERE First name%='Hülya') Ob. SELECT SUBSTR(last_name, 1,3) FROM Manager WHERE Mngr_Code= (SELECT Mngr_Code FROM Employees WHERE First_name='Hülya') O SELECT REPLACE(d.First_name, i) FROM Manager d JOIN Employees p on (d.Mngr_Code%3Dp.Mngr_Code) Od. SELECT SUBSTR(First_name, 1,2) FROM Manager d JOIN Employees p on (d.Mngr_Code%3Dp.Mngr_Code) Oe. SELECT INSTR(First_name, I) FROM Employees WHERE Last_name%3DTarık Of. SELECT LOWER(d.First_name) FROM Manager d JOIN Employees p on (d.Mngr_Code%3Dp.Mngr_Code) Og. SELECT SUBSTR(d.last_name, 1,3) FROM Manager First_name%3D'Hülya'

Which query returns the first 3 characters of last name of the manager who work with employee named as Hülya? O a. SELECT SUBSTR(First_name, 1,3) FROM Manager WHERE Mngr_Code=D (SELECT Mngr_Code FROM Employees WHERE First name%='Hülya') Ob. SELECT SUBSTR(last_name, 1,3) FROM Manager WHERE Mngr_Code= (SELECT Mngr_Code FROM Employees WHERE First_name='Hülya') O SELECT REPLACE(d.First_name, i) FROM Manager d JOIN Employees p on (d.Mngr_Code%3Dp.Mngr_Code) Od. SELECT SUBSTR(First_name, 1,2) FROM Manager d JOIN Employees p on (d.Mngr_Code%3Dp.Mngr_Code) Oe. SELECT INSTR(First_name, I) FROM Employees WHERE Last_name%3DTarık Of. SELECT LOWER(d.First_name) FROM Manager d JOIN Employees p on (d.Mngr_Code%3Dp.Mngr_Code) Og. SELECT SUBSTR(d.last_name, 1,3) FROM Manager First_name%3D'Hülya'

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

SQL QUESTIONS

Which query returns the first 3 characters of last name of the manager who work with employee named as Hülya? a. SELECT SUBSTR(First_name, 1,3) FROM Manager WHERE Mngr_Code=D (SELECT Mngr_Code FROM Employees WHERE First_name=D"Hülya') b. SELECT SUBSTR(last_name,1,3)) FROM Manager WHERE Mngr_Code= (SELECT Mngr_Code FROM Employees WHERE First_name%=D'Hülya) C. SELECT REPLACE(d.First_name, i) FROM Manager d JOIN Employees p on (d.Mngr_Code=p.Mngr_Code) d. SELECT SUBSTR(First_name, 1,2) FROM Manager d JOIN Employees p on (d.Mngr_Code=Dp.Mngr_Code) e. SELECT INSTR(First_name,1) FROM Employees WHERE Lastname%3DTanik Of. SELECT LOWER(d.First_name) FROM Manager d JOIN Employees p on (d.Mngr_Code=p.Mngr_Code) Og. SELECT SUBSTR(d.last_name,1,3) FROM Manager First_name%3D'Hülya" Sonraki sayfa
Transcribed Image Text:Which query returns the first 3 characters of last name of the manager who work with employee named as Hülya? a. SELECT SUBSTR(First_name, 1,3) FROM Manager WHERE Mngr_Code=D (SELECT Mngr_Code FROM Employees WHERE First_name=D"Hülya') b. SELECT SUBSTR(last_name,1,3)) FROM Manager WHERE Mngr_Code= (SELECT Mngr_Code FROM Employees WHERE First_name%=D'Hülya) C. SELECT REPLACE(d.First_name, i) FROM Manager d JOIN Employees p on (d.Mngr_Code=p.Mngr_Code) d. SELECT SUBSTR(First_name, 1,2) FROM Manager d JOIN Employees p on (d.Mngr_Code=Dp.Mngr_Code) e. SELECT INSTR(First_name,1) FROM Employees WHERE Lastname%3DTanik Of. SELECT LOWER(d.First_name) FROM Manager d JOIN Employees p on (d.Mngr_Code=p.Mngr_Code) Og. SELECT SUBSTR(d.last_name,1,3) FROM Manager First_name%3D'Hülya" Sonraki sayfa
TEAMS EMPLOYEES Team_id Team_Name Expired Date Employee id Dept id Employee id Mngr_Code Age First Name Last Name Gender Number 0f Children D19 UIX 23.04.2020 520 10 104 Mgr10 48 Selami Sevinç Male D16 DMN 15.04.2021 412 20 185 Mor04 29 İlker Güzel Male D20 Aky 13.012022 185 10 412 Mg14 33 Veral Akyaka Fmale 5 D15 Celebrity 06 03.2022 301 15 301 Mgr29 34 Hüla Tarık Fmale 2 D09 Purple 10,02.2022 902 15 902 Mgr 10 27 Derya Mantar Fmale 4 Cyk 11.03.2022 604 30 D05 Mgr29 21 Bulen: Balcı Male 520 Mgr10 Seval Yorüksun Fmale SALARIES Mgr29 Batu Mert Male Salary_ld Wage Employee id 604 39 S7 65 301 MANAGERS 59 190 604 Mngr Code First Name Last Name Gender Department $11 35 520 Mgr10 Hakan Yalmaz Male Accounting $13 45 412 Mgr04 Akif Kaya Male Software Answer SQL Question according to above Tables. Mgr29 Melek Dincer Female Human Resources Mgr14 Yakut Susler Male Law
Transcribed Image Text:TEAMS EMPLOYEES Team_id Team_Name Expired Date Employee id Dept id Employee id Mngr_Code Age First Name Last Name Gender Number 0f Children D19 UIX 23.04.2020 520 10 104 Mgr10 48 Selami Sevinç Male D16 DMN 15.04.2021 412 20 185 Mor04 29 İlker Güzel Male D20 Aky 13.012022 185 10 412 Mg14 33 Veral Akyaka Fmale 5 D15 Celebrity 06 03.2022 301 15 301 Mgr29 34 Hüla Tarık Fmale 2 D09 Purple 10,02.2022 902 15 902 Mgr 10 27 Derya Mantar Fmale 4 Cyk 11.03.2022 604 30 D05 Mgr29 21 Bulen: Balcı Male 520 Mgr10 Seval Yorüksun Fmale SALARIES Mgr29 Batu Mert Male Salary_ld Wage Employee id 604 39 S7 65 301 MANAGERS 59 190 604 Mngr Code First Name Last Name Gender Department $11 35 520 Mgr10 Hakan Yalmaz Male Accounting $13 45 412 Mgr04 Akif Kaya Male Software Answer SQL Question according to above Tables. Mgr29 Melek Dincer Female Human Resources Mgr14 Yakut Susler Male Law
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS