List full details of departments that don't have any graduate students. Find the name and the age of the youngest professors Count the number of different professors names. Find the names of student who have work in all projects. Find the name and the age of the youngest graduate student (use subquery). Find the names of professors supervising graduate students that age >22.
List full details of departments that don't have any graduate students. Find the name and the age of the youngest professors Count the number of different professors names. Find the names of student who have work in all projects. Find the name and the age of the youngest graduate student (use subquery). Find the names of professors supervising graduate students that age >22.
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
100%
- List full details of departments that don't have any graduate students.
- Find the name and the age of the youngest professors
- Count the number of different professors names.
- Find the names of student who have work in all projects.
- Find the name and the age of the youngest graduate student (use subquery).
- Find the names of professors supervising graduate students that age >22.
![professors
Projects
age
Alexandra 30
SSN
R_specialty rank
budget ssn_pro
name
pnumber
starting
ending Date
name
1
Science
Assistant Professor
Date
English
Mathmatic Professor
2
Alex
35
Assistant Professor
1/3/2020
20/3/2020
1/4/2020
1/3/2020
20/3/2020
9/4/2020
20/4/2020
29/4/2020
9/4/2020
29/5/2020
1
Analysis 1
300
1
3
Lesbon
40
2.
Translate
400
2
4
smith
32
Science
null
3
Calculation
600
3
5
Loại
42
Computer
Professor
4
Analysis_2
200
1
algorithm
320
Work_In
departments
work_dept
Ssn
dnumber time
pnumber
dnumber name
Ssn pro
ssn
Office
1
1.
New York
1
1
3:00pm
1
IT
1
3
2
12:30am
3
2
2.
Science
Boston
3
2
3
1:00pm
2
3
3
Engineering
Boston
3
1
2
3:00am
1
2.
4
Health sciences
New York
1
3
4
4
11:00am
5
Accounting
Chicago
1
work_proj
Gradute
SSN
Gradute NO
pnumber
1
1.
1.
Avg_degree age
dnumber advise
SSN
name
2
1.
2
1
Laila
85
24
1
1.
3
1
2
Ali
90
22
1.
2.
4
1.
4
3
Ahmed
95
26
2
5
1
5
4
Sami
null
30
2.
3
1.
2
1
Amany
Andre
5
85
32
2
2.
2
2
95
33
3
5
3
4
3](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4ef8698d-53b1-412e-9b5b-578c0041cc78%2Fa1c871f8-5214-435f-a0ec-c25a882c63a3%2F8s6sss9_processed.png&w=3840&q=75)
Transcribed Image Text:professors
Projects
age
Alexandra 30
SSN
R_specialty rank
budget ssn_pro
name
pnumber
starting
ending Date
name
1
Science
Assistant Professor
Date
English
Mathmatic Professor
2
Alex
35
Assistant Professor
1/3/2020
20/3/2020
1/4/2020
1/3/2020
20/3/2020
9/4/2020
20/4/2020
29/4/2020
9/4/2020
29/5/2020
1
Analysis 1
300
1
3
Lesbon
40
2.
Translate
400
2
4
smith
32
Science
null
3
Calculation
600
3
5
Loại
42
Computer
Professor
4
Analysis_2
200
1
algorithm
320
Work_In
departments
work_dept
Ssn
dnumber time
pnumber
dnumber name
Ssn pro
ssn
Office
1
1.
New York
1
1
3:00pm
1
IT
1
3
2
12:30am
3
2
2.
Science
Boston
3
2
3
1:00pm
2
3
3
Engineering
Boston
3
1
2
3:00am
1
2.
4
Health sciences
New York
1
3
4
4
11:00am
5
Accounting
Chicago
1
work_proj
Gradute
SSN
Gradute NO
pnumber
1
1.
1.
Avg_degree age
dnumber advise
SSN
name
2
1.
2
1
Laila
85
24
1
1.
3
1
2
Ali
90
22
1.
2.
4
1.
4
3
Ahmed
95
26
2
5
1
5
4
Sami
null
30
2.
3
1.
2
1
Amany
Andre
5
85
32
2
2.
2
2
95
33
3
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)
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning