d. write a query to retrieve the name of graduate student and student advisor name of all graduate student.
d. write a query to retrieve the name of graduate student and student advisor name of all graduate student.
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...
Related questions
Question
d. write a query to retrieve the name of graduate student and student advisor name of all graduate student.
![professors
Projects
SSN name
age R_specialty rank
pnumber name
starting
ending Date budget ssn_pro
Alexandra | 30
Science
Assistant Professor
Date
English
Assistant Professor
9/4/2020
20/3/2020 20/4/2020
29/4/2020
9/4/2020
20/3/2020 29/5/2020
2
Alex
35
1
Analysis_1 1/3/2020
300
1
3.
Lesbon
40
Mathmatic
Professor
2
Translate
400
2
smith
Science
null
Calculation 1/4/2020
Analysis_2 1/3/2020
algorithm
4
32
3
600
3
Loai
42
Computer
Professor
4
200
1
5
320
5
Work_In
departments
work_dept
pnumber
Ssn dnumber time
1
ssn
dnumber name
Office
Ssn_pro
1
1
New York
1
3:00pm
IT
1
3
2
12:30am
2
2
Science
Boston
3
2
3
1:00pm
2
1
1
3
3
Engineering
Health sciences New York
Boston
3
1
2
3:00am
2
4
3
4
11:00am
5
Accounting
Chicago
1
work_proj
Gradute
SSN Gradute_NO pnumber
1
1
SSN
name
Avg degree age
dnumber advise
2
2
1
Laila
85
24
1
1.
3
Ali
90
22
1
2
4
4
13
|2
3
Ahmed
95
26
2
5
1
5
Sami
nll
30
3
1
2
1
Amany
85
32
2
2.
3
2
6
Andre
95
33
5
3
4
3](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fba558c8e-f969-419b-b97d-45af5ed7df79%2Fc9981b18-9dbd-427e-b0b8-e8e496582435%2Fmb612f8_processed.jpeg&w=3840&q=75)
Transcribed Image Text:professors
Projects
SSN name
age R_specialty rank
pnumber name
starting
ending Date budget ssn_pro
Alexandra | 30
Science
Assistant Professor
Date
English
Assistant Professor
9/4/2020
20/3/2020 20/4/2020
29/4/2020
9/4/2020
20/3/2020 29/5/2020
2
Alex
35
1
Analysis_1 1/3/2020
300
1
3.
Lesbon
40
Mathmatic
Professor
2
Translate
400
2
smith
Science
null
Calculation 1/4/2020
Analysis_2 1/3/2020
algorithm
4
32
3
600
3
Loai
42
Computer
Professor
4
200
1
5
320
5
Work_In
departments
work_dept
pnumber
Ssn dnumber time
1
ssn
dnumber name
Office
Ssn_pro
1
1
New York
1
3:00pm
IT
1
3
2
12:30am
2
2
Science
Boston
3
2
3
1:00pm
2
1
1
3
3
Engineering
Health sciences New York
Boston
3
1
2
3:00am
2
4
3
4
11:00am
5
Accounting
Chicago
1
work_proj
Gradute
SSN Gradute_NO pnumber
1
1
SSN
name
Avg degree age
dnumber advise
2
2
1
Laila
85
24
1
1.
3
Ali
90
22
1
2
4
4
13
|2
3
Ahmed
95
26
2
5
1
5
Sami
nll
30
3
1
2
1
Amany
85
32
2
2.
3
2
6
Andre
95
33
5
3
4
3
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY