Question: Q 1 [ 5 pt ] : Report the names of the professor whose office phone numbers end with 2 1 . Q 2 [

Q1[5pt]: Report the names of the professor whose office phone numbers end with 21.
Q2[5pt]: Report the names of the professors who supervise more than 2 students.UseInner Joinmethod.
Q3[5pt]: Report the number of students who entered in the same year, and the total number of students at the last row.
Q4[6pt]: Report the department with the least number of professors, and the number of professors.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!